Configuring Rank Change Parameters 

Use

Use this screen to configure the parameters specific to the Rank Change template. See Rank Change (OLAP) for the description, business question, and workflow for using this template.

 

Procedure

...

       1.      In the Calculate Change in section of the screen, select the type of rank and its value in the Rank Type and Value fields. You may select from the following rank types:

¡        Top Count

¡        Bottom Count

¡        Top Percent

¡        Bottom Percent

If you select a count rank type, the values in the Value field are numeric. If you select a percent rank type, the values in the Value field correspond to percentages.

For example, if you select Top Count and a value of 5, you want to calculate the change in rank of your top three members between one period and another. If you select Top Percent and a value of 10, you want to calculate the change in rank of your top 10% of members between one period and another.

 

       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 rank change 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 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.

 

       4.      Click Next.

 

Result

You proceed to the Define Filters screen.

 

Example

The result of a Rank Change query is displayed in a table with five columns such as the below:

Rank Change Query Result

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:

       1.      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.

       5.      Next, it calculates the Top N results for those same members in the comparison period (Rank Comparison Period column).

       6.      Finally, the query computes the difference between the base and comparison period ranks, and delivers that value in the Rank Difference column.