Inserting two overlapping hyperblocks

Hyperblocks are one of several types of object in which you can display a list. 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. Ensure that the Tutorial1 report is open in Design mode.
  2. Open the Database Structure pane in the Application Explorer.
  3. Expand Database Aliases.
    Note: The term Database Alias is used only in the Application Studio client. Elsewhere, the term Data Connection is used.
  4. Expand BestPracticesOLAP.
  5. Expand ANALYSIS.
  6. Click cell B11 and drag across to cell C11.
    The two cells are highlighted.
  7. Drag the Product dimension, from the database structure, 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 expands horizontally or vertically. If the arrow is horizontal, click it to change it to vertical.

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