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.

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 Samples application.

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 hyperblocks. 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.

  1. Create or open the report described in the topic 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: The Product and Period dimensions are referenced by their cell references. But, for the Region dimension, the All Regions dimension is selected.
  5. 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.
Related topics