Adding a list object as a data slicer

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

  1. Click cell C6 and then click the Combo Box icon 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 formula.
  4. In Design mode, click cell C11 and open the Edit OLAP Formula wizard.
  5. Click Units.
    A list is enabled. In the list, the name of the combo box is displayed as ReportObjects.ListView3.text.
  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.