Show TOC

Object documentationPercentage Growth Parameters Locate this document in the navigation structure

 

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?

Structure

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.

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.