Use the Configure Percentage Growth Parameters screen to configure parameters specific to the Percentage Growth template. With this template, you can build queries that calculate the percentage by which a specific measure has increased or decreased for a selected member in comparison to the same period of time previously or subsequently.
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 (and the results are expressed as a percentage).
This template can address business questions such as the following:
By what percentage did my sales increase this year compared to last year?
The main sections and controls of this screen are listed in the following table:
Section |
Control |
Description |
---|---|---|
Calculate |
Absolute percentage growth of measure |
Lists all measures in the cube on which the query is based. Select the measure for which you want to calculate growth. |
For Members of |
Dimension |
Lists all 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. |
|
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. |
|
Between Base and Comparison Periods |
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. |
The result of a Percentage Growth query is displayed in a table with five columns such as the below:
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.