Use the Configure Rank Change Parameters screen to configure parameters specific to the Rank Change template. With this template, you can build queries that, based on a specific measure, calculate the change in rank of members of a particular level compared with their rank from a previous period.
This template borrows from the functionality of the Top N template in order to select the members of the base period.
This template can address business questions such as the following:
What is the change in rank for my top ten customers between last year and this year?
The main sections and controls of this screen are listed in the following table:
Section |
Control |
Description |
---|---|---|
Calculate Change in |
Rank type |
Select from the following rank types:
|
Value |
Enter the rank value. For Count rank types, the value is numeric. For Percent rank types, the value corresponds to a percentage. For example:
|
|
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. |
|
According to measure |
Lists all measures in the cube on which the query is based. Select the measure to use for the rank change calculation. |
|
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 from which to calculate the rank change. |
|
Comparison period |
Lists all members in the currently selected level. Select the comparison period with which to calculate the rank difference. |
The result of a Rank Change query is displayed in a table with five columns such as the below:
Product |
Base Period |
Rank Comparison Period |
Rank Base Period |
Rank Difference |
---|---|---|---|---|
Wine |
1500 |
6 |
1 |
5 |
Beer |
1300 |
8 |
2 |
6 |
Juice |
800 |
1 |
3 |
-2 |
There are three steps to the calculation in this query:
The query first computes the results of a Top N query in the base period you specify (values in Base Period and Rank Base Period columns). This also selects the members that will appear on the rows in the table.
Next, it calculates the Top N results for those same members in the comparison period (Rank Comparison Period column).
Finally, the query computes the difference between the base and comparison period ranks, and delivers that value in the Rank Difference column.