Using an object reference

This example is based on the Samples application, which can be enabled in on-premises environments. It 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.
  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.
Related topics