Adding a list object as a data slicer

List objects are hyperblocks, combo boxes, list boxes and option buttons. We will add a combo box, linked to the Measure dimension. This enables you to change the slice of data displayed in the report by selecting different measures.

To add the combo box:

  1. Click cell C6 and then click Combo Box in the Objects toolbar.
  2. Open the Database Structure and expand the ANALYSIS cube. Drag the Measures dimension onto the combo box in cell C6.
  3. Specify Measure in cell B6 to label the combo box.
    In View Mode, you can now select different measures from the combo box. This does not change the data in the report because the combo box is not yet referenced by the OLAP Server formula.
  4. In Design Mode, click cell C11 and open the Edit OLAP Formula dialog.
    The element for the Measure dimension is displayed as Units.
  5. Double-click Units.
    A drop-down list is enabled. In the list, the name of the combo box is displayed as ReportObjects.ListView3.text (list view objects are numbered sequentially, and the two hyperblocks in the report are list objects 1 and 2).
  6. Select ReportObjects.ListView3.text and click OK.
    In View Mode, the figures in the report now change according to the measure you select in the combo box.
    Note: If we had inserted the combo box before we created the OLAP formula, the formula would have automatically referenced it.