Using wildcards and global variables to filter the unique name

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. Create a report variable named rv_ProductUnique.
  2. Set the value of the variable to the unique name of an element of the Product dimension (for example, [Product].[All Tires].[Car Tires All Season] )
  3. In Design Mode, click the hyperblock.
    The List Designer is enabled.
  4. Click Filter in the List Designer.
  5. Click New Filter.
  6. In Filter Settings, select Filter By > Unique name.
  7. Select Filter Type > Wildcard.
  8. Select Condition > Equals.
  9. In the Wildcard field, open the Edit Custom MDX dialog.
  10. Click Variables and double-click rv_ProductUnique in the list of global variables.
    The variable is displayed as =ReportVariables.rv_ProductUnique.Text.
  11. Edit the formula by adding &"*" to the end (=ReportVariables.rv_ProductUnique.Text&"*")
    In View Mode, All Season Tires and its children are displayed.
Parent topic: Using AND, OR and NOT operators