1.
What can be created if the financial analyst wants to look at the data by fiscal year, while the senior manager wants to analyze the data by calendar year?
2.
What can be applied to a category if only the parent and child categories are required?
3.
The time dimension contains levels for year, quarter, and month. How can the month levels in 2008 be retained while removing them from 2007?
4.
What must be unique to create an alternate hierarchy?
5.
What can a developer set up to analyze actual, planned, and forecasted budget information that do not rollup into a single root category?
6.
The dimensions in the model include Product, Customer, and Order. If the Powercube should focus on the sales orders, how can the developer remove customer data?
7.
The Region dimension is organized by Territory, Country, and City. Which option can be applied to only show data for the United States and its descendants?
8.
A dimension organizes all the regions by Country and City. Disregarding the hierarchical organization, how can the five best performing regions be grouped?
9.
A developer created a cube for each regional Sales Manager. Each cube should contain only the transactional details for each Sales Manager's region, as well as the summarized values for other regions. What should be created?
10.
What can be created to determine the monthly growth showing the percentage of change between Current Month and Last Month for all measures included in the PowerCube?