Inserting two overlapping hyperblocks

Hyperblocks are objects in which lists are displayed. The report displays a list of products and a list of dates. The dates form the columns of the report and the products form the rows.

  1. Open the Database Structure pane in the Repository Explorer.
  2. Expand Database Aliases.
  3. Expand Best Practices OLAP.
  4. Expand ANALYSIS.
    The dimensions of the Analysis cube are displayed.
  5. Click cell B11 and drag across to cell C11.
    The two cells are highlighted.
  6. Drag the Product dimension into cell B11.
    A hyperblock is created in cells B11 to C11. A hyperblock comprises a key output cell and a data cell. Here, cell B11 is the key output cell.

    The hyperblock has an arrow to indicate whether the hyperblock will expand horizontally or vertically. If the arrow is horizontal, click it to change it to vertical.

  7. Click cell C10 and drag the Period dimension into it.
    A second, horizontal, hyperblock is created. The Product and Period hyperblocks overlap at cell C11. Cell C11 is the data cell of both hyperblocks.
  8. Click File > Save report.