Trend Over Time (OLAP) 
Purpose
The Trend Over Time template is an OLAP trend template with which 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.
You should use this template if you would like to 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?
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 Trend Over Time template, the wizard steps you through the following process flow:
...
2. Configure Trend Over Time parameters
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:
Example
For an example of working with the Trend Over Time template, see Configuring Trend Over Time Parameters.