RP002
Report RP002 is an example of how the Data Area can be used to filter one set of data with another. Specifically, it shows how to display budget figures for one year only where the actual figures for the previous year were above a specified amount.
The report has two hyperblocks. The first has two value cells. In the first value cell, a formula returns the actual results for products in 2002. In the second value cell, a formula returns the budgeted figures for 2003.
This table shows the hierarchies and elements to which the formulas refer:
| Hyperblock 1 | |
|---|---|
| Value cell 1 - actual results for 2002 | Value cell 2 - budgeted results for 2003 |
| CHANNEL: All Channels | CHANNEL: All Channels |
| MEASURE: Units | MEASURE: Units |
| POS: All POS | POS: All POS |
| PERIOD: 2002 | PERIOD: 2003 |
| REGION: All Regions | REGION: All Regions |
| VALTYPE: Actual | VALTYPE: Budget |
The second hyperblock also displays the budgeted figures for products in 2003 - but it has a filter to display only those elements where the actual results in 2002 were above 80000.
The filter is "Value greater than 80000" and the Data Area refers to these hierarchies and elements:
- CHANNEL: Current Element. That is, All Channels.
- MEASURE: Units
- POS: Current Element. That is, All POS.
- PERIOD: 2002
- REGION: Current Element. That is, All Regions.
- VALTYPE: Actual
To see the filter and Data Area:
- Display Report RP002
- In Design Mode, click the border of the second hyperblock.
- In the List Designer, open the Filter pane.