Configuring Trend Over Time Parameters 

Use

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

 

Procedure

...

       1.      In the Display section of the screen, select the measure for which you want to display a trend from the Trend in measure drop-down list. This list shows all the measures in the cube on which the query is based.

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

 

       3.      In the During Date Range section of the screen, select the start and end periods for the trend according to the values in the table below:

During Date Range Parameters

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 trend calculations.
From	Lists all members in the currently selected level.	Select the start period of the trend.
To	Lists all members in the currently selected level.	Select the end period of the trend.

 

       4.      Click Next.

 

Result

You proceed to the Define Filters screen.

 

Example

You want to identify the trend in unit sales for product families over the last half of the year. To create this query, configure the values on this screen in the following manner:

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

 

Display section:

Trend in measure = Unit Sales

 

For Members of section:

Dimension = Product

Hierarchy = Product

Level = Product Family

 

During Date Range section:

Time dimension = Time

Hierarchy = Time

Period level = Month

From = July

To = December

 

The result of this query is displayed in a table similar to the below:

Trend Over Time Query Result

Product Family	Jul	Aug	Sep	Oct	Nov	Dec
Drink	2,205	1,921	1,939	1,898	2,344	2,419
Food	17,036	15,741	14,663	14,232	18,278	19,356
Non-Consumable	4,522	4,035	3,786	3,828	4,648	5,021