Entering content frame

Process documentation Percentage Growth (OLAP) Locate the document in its SAP Library structure

Purpose

The Percentage Growth template is an OLAP variance template with which 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).

You should use this template if you would like to address business questions such as the following:

By what percentage did my sales increase this year compared to last year?

 

Prerequisites

You have an OLAP data service configured as a BI system.

 

Process Flow

After using the BI Query Wizard to select an OLAP data service and the Percentage Growth template, the wizard steps you through the following process flow:

...

       1.      Select a cube

       2.      Configure Percentage Growth parameters

       3.      Define filters

       4.      Preview the result

 

Result

After you have completed the wizard screens according to the process above and clicked Finish, you return to the Visual Composer workspace, where a new data service has been created with the query you have configured.

A data service created with the BI Query Wizard is configured automatically with a start input and a table view as output. These three elements together constitute a complete iView, ready for preview and deployment to your portal.

To continue working with your data service and query, see:

·        Working With Queries

·        Using the MDX Editor

 

Example

For an example of working with the Percentage Growth template, see Configuring Percentage Growth Parameters.

 

 

Leaving content frame