Hyperblocks 1, 2 and 3
Hyperblocks 1, 2 and 3 contain the same formula.
Hyperblock 3 does not display any data in View Mode. In Design Mode, Hyperblock 3 displays the #REF error.
The formula refers to these dimensions and elements:
- CHANNEL: All Channels
- MEASURE: Gross Margin
- POS: All POS
- PERIOD: All Years
- REGION: All Regions
- VALTYPE: Actual.
To see this, open Design Mode and click the right-hand cell of each hyperblock. The formula is displayed in the Formula Editor.
All elements except 'Actual' are the default elements of their dimensions.
Hyperblocks 2 and 3 have a Value filter to display only values greater than 30000000. For Hyperblock 2, the Data Area is correctly defined. For Hyperblock 3, the Data Area is not defined.
To define the Data Area for Hyperblock 3: