Nesting hyperblocks

You can nest hyperblocks so that one or more hyperblocks are contained within another. You can use this technique to generate separate tables of data from a single formula. Each table displays a different slice of data, controlled by the outermost hyperblock. Two of the sample reports delivered with Application Studio use nested hyperblocks. The reports are 'Top Units' and 'Highest Costs' in, respectively, the Sales and Finance subfolders in the Report Catalog. In the Report Catalog, expand Best Practices Templates > Reports > Reporting.

This example extends the 'Overlapping hyperblocks' example by nesting the overlapping hyperblocks within a hyperblock which is linked to the Region dimension of the Analysis cube of the Best Practices sample database.

SeeOverlapping hyperblocks.

This example also demonstrates the importance of this note:

Note: If you add a formula to the value cell of a hyperblock, or to the shared value cell of overlapping hyperblocks, the formula automatically references the hyperblock(s). It also automatically references any existing lists in the report - in combo boxes, for example. If you subsequently add further list objects, you must manually adjust the formula to reference them.

If you insert a formula outside a hyperblock, the formula automatically references any other list objects in the report, but not the hyperblock.

A further example of nesting hyperblocks is in the topic 'Nesting Charts.'.

See Nesting charts.

  1. Create or open the report described in 'Overlapping hyperblocks'.
  2. Click cell B9 and then drag the Region dimension from the database structure into it.
    A hyperblock is created which encloses the overlapping hyperblocks in cells B11 and C10.
  3. View the report in View Mode..
    A separate table of data is displayed for each parent element of the Region dimension. You can expand each region to display separate tables for the child elements.
    Note: The data is the same in each table. This is because the formula in C11 has not been edited to reference the Region hyperblock.
  4. In Design Mode, click cell C11 and then click Edit OLAP Formula on the Objects toolbar. .
    The Edit OLAP Formula dialog is displayed.
    Note: In the Element column, the Product and Period dimensions are referenced by their cell references. But, for the Region dimension, the All Regions dimension is selected.
  5. Double-click All Regions and select B9 from the drop-down list.
  6. Click OK and view the report in View Mode.
    The data in each table refers to its region.
Parent topic: Hyperblocks
Related topics