Using custom MDX

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.

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) .
  6. Click OK.
    In View mode, only the base elements of the list are displayed.