SAP Online Help 07.09.2004
SAP NetWeaver Visual Composer: User Guide 79
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:
...
1. Select a cube [Page 106]
2. Configure Planned vs. Actual parameters [Page
80]
3. Define filters [Page
107]
4. Preview the result [Page
119]
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:
• Working With Queries [Page
130]
• Using the MDX Editor [Page
125]
Example
For an example of working with the Planned vs. Actual template, see Configuring Planned vs.
Actual Parameters [Page 80].
