SAP Online Help 07.09.2004
SAP NetWeaver Visual Composer: User Guide 64
Cumulative Total (OLAP)
Purpose
The Cumulative Total template is an OLAP dynamic calculation template with which you can
build queries that cumulate the value of a measure over a specific date range.
In the result, the measure is first cumulated over the date range specified, and the starting cell
displays that initial period's sum. Thereafter, each cell in the grid displays the accumulation of
the previous sum plus the sum in the next time period, and so on.
This kind of query is particularly useful if you have a specific target to hit by the end of the
year, for example, and you want to track your progress toward it throughout the year.
You should use this template if you would like to address business questions such as the
following:
What is my monthly year-to-date expense total?
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 Cumulative Total
template, the wizard steps you through the following process flow:
...
1. Select a cube [Page 106]
2. Configure Cumulative Total parameters [Page
65]
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 Cumulative Total template, see Configuring Cumulative
Total Parameters [Page 65].
