Entering content frame

Procedure documentation Configuring Moving Average Parameters Locate the document in its SAP Library structure

Use

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

 

Procedure

...

       1.      In the Calculate section of the screen, select the measure for which you want to display a moving average in the Moving average of measure drop-down list. This list shows all the measures in the cube on which the query is based.

       2.      In the Based on number of periods field, enter the number of time periods on which to base the average.

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

 

       4.      Configure the parameters in the Display Date Range section of the screen according to the actions in the table below:

Display Date Range

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 upon which to base the date range display.

From

Lists all members in the currently selected level.

Select the start period of the date range to display.

To

Lists all members in the currently selected level.

Select the end period of the date range to display.

 

       5.      Click Next.

 

Result

You proceed to the Define Filters screen.

 

Example

 

You want to know the average manufacturing costs for March and April based on the previous four months. To create this query, configure the values on this screen in the following manner:

This graphic is explained in the accompanying text

This example assumes you have similar types of metadata available in your data service.

 

 

Calculate section:

·        Moving average of measure = Manufacturing Cost

·        Based on number of periods = 4

 

For Members of section:

·        Dimension = Product

·        Hierarchy = Product

·        Level = Product Name

 

Display Date Rangesection:

·        Time dimension = Time

·        Hierarchy = Time

·        Period level = Month

·        From = December

·        To = April

 

The data used to calculate the moving average, together with the result of this query (the yellow cells), are shown in the tables below:

 

Moving Average Query: Data Reference

Part

Dec

Jan

Feb

Mar

Apr

Part A

$25

$15

$10

$10

$5

Part B

$20

$10

$5

$5

$15

Part C

$5

$5

$5

$5

$5

 

Moving Average Query: Result

Part

Dec

Jan

Feb

Mar

Apr

Part A

 

 

 

$15

$10

Part B

 

 

 

$10

$9

Part C

 

 

 

$5

$5

 

Each cell in the result shows the average of its own figure and the previous three months, since the Based on number of periods value is set to 4 months.

 

 

Leaving content frame