Growth Function

Growth type computed measures are used to calculate the growth of a measure over a certain time period. The Growth type measures are of two types:

  • Absolute – where the growth of a measure can be calculated either in absolute terms, that is a simple difference.
  • Percentage – where the growth of a measure is calculated on a percentage basis.

Absolute Growth Option

  1. Select the Absolute Growth option and enter the details as tabulated.
    The following table describes the fields in the Absolute Growth Option.

    Table 8-31 Fields in the Absolute Growth Option and their Description

    Field Description
    Select the base on which to calculate the growth Select it from the drop-down list. The available option is Consecutive Period.
    Select the period Select the period from the drop-down list for which you want the growth to be monitored. The available options are Year, Quarter or month.

    Note:

    If the time Dimension period specified in the cube is Year, Quarter, and Month, it takes the previous period of the Time Level.
  2. Select the measure from the Select the Measure pane. Depending on the Information Domain you are logged in to, the measures for that domain are displayed in the pane. Select the measure from the pane. On selecting the measure, the growth of the measure will be calculated for the consecutive period for a year.

Percentage Growth Option

  1. Select the Percentage Growth option and enter the details as tabulated.
    The following table describes the fields in the Percentage Growth Option.

    Table 8-32 Fields in the Percentage Growth Option and their Description

    Field Description
    Select the base on which to calculate the growth Select it from the drop-down list. The available option is Consecutive Period.
    Select the period Select the period from the drop-down list for which you want the growth to be monitored. The available options are Year, Quarter or month.
  2. Select the measure from the Select the Measure pane. Depending on the Information Domain you are logged in to, the measures for that domain are displayed in the pane. Select the measure from the pane. On selecting the measure, the growth of the measure will be calculated for the consecutive period for a year.