Show TOC

Object documentationTrend Over Time Parameters Locate this document in the navigation structure

 

Use the Configure Trend Over Time Parameters screen to configure parameters specific to the Trend Over Time template. With this template, you can build queries that display the trend of a specific measure for a selected member over time.

This is a common type of business query with which you track performance over a specific time period, helping you to easily identify and react to trends from one year (or other time period) to the next.

This template can address business questions such as the following:

What is the trend in my gross margin over the past few years? Is it increasing or decreasing?

Structure

The main sections and controls of this screen are listed in the following table:

Section

Control

Description

Display

Trend in measure

Lists all measures in the cube on which the query is based.

Select the measure for which you want to display a trend.

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.

During Date Range

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.

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:

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:

Unit Sales Trend: Month to Month

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