Show TOC

Object documentationRank Change Parameters Locate this document in the navigation structure

 

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?

Structure

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:

  • Top Count

  • Bottom Count

  • Top Percent

  • Bottom Percent

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:

  • If you select Top Count and enter a Value of 5, you want to calculate the change in rank of your top five members between one period and another.

  • If you select Top Percent and enter a Value of 10, you want to calculate the change in rank of your top 10% of members between one period and another.

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.

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.

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

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