Using the OLAP metadata hierarchy to select different views within a report

  1. Create a report with combo boxes in cells B3, B5, and B7.
  2. Drag the OLAP metadata hierarchy from the Accessories pane onto each combo box.
  3. Name the first combo box Alias, the second Cube and the third, Dimension.
  4. Select the Alias combo box. In the List Designer, open Structure Selection and select Repository_infor in the Children of list. Save the changes to the list.
  5. Select the Cube combo box. In Structure Selection select <Edit Formula> from the Children of list.
  6. On the Variables tab of the Edit Formula dialog box, expand ListViews and double click Alias.
    The Cube combo box is now dependent on the Alias combo box.
  7. Select the Dimension combo box. Make it dependent on the Cube combo box.
    Now, the first combo box contains only database aliases. The second contains the cubes. The third contains the dimensions of the cube that is selected in the Cube combo box.
  8. Create a hyperblock in cell B9 of the report by dragging a dimension from a cube into the report.
  9. Select the hyperblock and open the Advanced pane in the List Designer. In the General section, click Best Practices Templates and select Edit Formula. Specify =Alias.attribute in the Edit Formula dialog box.
  10. Change the cube name so that it refers to the attribute of the Cube combo box. Replace the cube name with =cube.attribute.
  11. Now replace both the dimension and hierarchy with =dimension.attribute.
  12. In View mode, select an alias, cube, and dimension from the combo boxes.