Configuring Percentage Growth
Parameters 
Use
Use this screen to configure the parameters specific to the Percentage Growth template. See Percentage Growth (OLAP) for the description, business question, and workflow for using this template.
Procedure
...
1. In the Calculate section of the screen, select the measure for which you want to calculate growth from the Absolute percentage growth of measure drop-down list. This list shows all the measures in the cube on which the query is based.
2. In the For Members of section of the screen, select the level that contains the members you want to see in the query’s result using the parameters in the table below:
For Members Of Parameters
Parameter |
Values |
Action |
Dimension |
Lists all dimensions in the cube on which the query is based (see Selecting a Cube). |
Select the dimension that contains the hierarchy to display in the Hierarchy field. |
Hierarchy |
Lists all hierarchies in the currently selected dimension. |
Select the hierarchy that contains the level to display in the Level field. |
Level |
Lists all levels in the currently selected hierarchy. |
Select the level that contains the members you want to see in the query’s result. |
3. In the Between Base and Comparison Periods section of the screen, configure the base and comparison periods for the percentage growth according to the parameters in the table below:
Between Base and Comparison Periods Parameters
Parameter |
Values |
Action |
Time dimension |
Lists all the time dimensions in the cube on which the query is based. |
Select the dimension that contains the hierarchy to display in the Hierarchy field. |
Hierarchy |
Lists all hierarchies in the currently selected dimension. |
Select the hierarchy that contains the level to display in the Level field. |
Period level |
Lists all levels in the currently selected hierarchy. |
Select the level that contains the time granularity for the base and comparison periods. |
Base period |
Lists all members in the currently selected level. |
Select the base period for the growth calculation. |
Comparison period |
Lists all members in the currently selected level. |
Select the comparison period for the growth calculation. |
4. Click Next.
Result
You proceed to the Define Filters screen.
Example
The result of a Percentage Growth query is displayed in a table with five columns such as the below:
Percentage Growth Query Result
Product |
Base Period |
Comparison Period |
Difference |
Percentage Change |
Wine |
20 |
60 |
40 |
200% |
Beer |
80 |
60 |
-20 |
-25% |
Juice |
100 |
10 |
-90 |
-90% |
A percentage growth result may not always show a growth trend, as you can see from the sample results above. You may see a decrease or decline (negative value) in your growth result.
This template is similar to the Rank Change template, but it doesn't perform a Top N calculation to select the members of the base period. The results are expressed as a percentage change from the base period.