Using an object reference

This example procedure is based on the Best Practices sample database supplied with Application Studio and uses a hyperblock created from the Product dimension.
  1. In addition to the Product hyperblock, create a combo box and drop the Product dimension onto it.
    See Associating list objects with lists.
  2. Change the name of the combo box to ProductList.
    There are now two report objects linked to the Product dimension.
  3. Select the hyperblock and click Filter in the List Designer.
  4. Click New Filter
  5. In Filter Settings, select Filter By > Unique name.
  6. Select Filter Type > Wildcard.
  7. Select Condition > Equals.
  8. In the Wildcard field open the Edit Custom MDX dialog.
  9. Click Variables and expand ListViews.
  10. Double-click _ProductList.
    =ProductList.text is displayed.

    In View Mode, the hyperblock displays whichever element is displayed in the combo box. But it does not display the children of consolidated elements.

  11. Edit the formula by adding &"*" at the end (=ProductList.text&"*")
    In View Mode, the list contains whichever element is selected in the combo box. If the selected element is a consolidated element, it can be expanded and the child element displayed.
Parent topic: Using AND, OR and NOT operators