Using wildcards and global variables to filter the unique name

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. The Samples application is not available in the Infor cloud.
  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.
  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.