Using a regular expression in a variable

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_ShortString
  2. Set the value of the variable to a short string (for example, er)
  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 > Caption.
  7. Select Filter Type > Regular Expression.
  8. Select Condition > Equals.
  9. In the Regular Expression field open the Edit Custom MDX dialog.
  10. Select rv_ShortString from the list of report variables.
    The list contains all elements with captions containing the string 'er' (for example, Summer Tires).
Parent topic: Using AND, OR and NOT operators