Moving Average (OLAP) 
Purpose
The Moving Average template is an OLAP dynamic calculation template with which you can build queries that calculate the average values of selected measures based on specified time periods. You determine the time periods to be averaged, and you can use the result to analyze past or forecast future results. Typically, your forecasts are more accurate if you perform the average over larger time periods.
You should use this template if you would like to address business questions such as the following:
What are the average manufacturing costs of products A and B for Q2 and Q3, based on the previous four months?
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 Moving Average template, the wizard steps you through the following process flow:
...
2. Configure Moving Average 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 Moving Average template, see Configuring Moving Average Parameters.