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 2016. In the second value cell, a formula returns the budgeted figures for 2017.

This table shows the hierarchies and elements to which the formulas refer:

Hyperblock 1
Value cell 1 - actuals Value cell 2 - budget
CHANNEL: All Channels CHANNEL: All Channels
MEASURE: Units MEASURE: Units
POS: All POS POS: All POS
PERIOD: 2016 PERIOD: 2017
REGION: All Regions REGION: All Regions
VALTYPE: Actual VALTYPE: Budget

The second hyperblock also displays the budgeted figures for products in 2017 - but it has a filter to display only those elements where the actual results in 2016 were above 6 million.

The filter is Value greater than 6000000 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: 2016
  • REGION: Current Element. That is, All Regions.
  • VALTYPE: Actual

To display the filter and Data Area:

  1. Display Report RP002
  2. In Design mode, click the border of the second hyperblock.
  3. In the List Designer, open the Filter pane.