Planned vs. Actual (OLAP) 
Purpose
The Planned vs. Actual template is an OLAP variance template with which you can build queries that calculate the values of a measure defined as actual and a measure defined as planned, illustrating the difference between actual and expected results.
Results to business queries such as these can be key in optimizing sales. For example, if your result is far greater than your plan for a specific product, this could indicate a lost opportunity or insufficient supply for the demand.
You should use this template if you would like to address business questions such as the following:
How do my actual costs compare to the planned costs?
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 Planned vs. Actual template, the wizard steps you through the following process flow:
...
2. Configure Planned vs. Actual 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 Planned vs. Actual template, see Configuring Planned vs. Actual Parameters.