Using custom MDX

This example procedure is based on the Best Practices sample database supplied with Application Studio and uses a hyperblock created from the Product dimension.

This example returns only the base elements of a dimension.

  1. Select the hyperblock and click Filter in the List Designer.
  2. Click Filter in the List Designer.
  3. Click New Filter
  4. In Filter Settings, select Filter By > Custom MDX and open the Edit Custom MDX dialog box.
  5. In the right-hand pane, specify isleaf([product].currentmember)=True
  6. Click OK.
    In View Mode, only the base elements of the list are displayed.
Parent topic: Using AND, OR and NOT operators