Defining an embedded filter

Create an embedded filter when you want to apply it to only one dimension or query subject.

Embedded filters that have the Usage property set to Security are used to secure data in the model. These filters are used with security views. For more information, see Securing packages.

Procedure

  1. In Project Explorer, right-click the dimension or query subject for which you want to define the filter, and click Open Editor.
  2. On the Filters tab, click the New Filter icon new filter icon.

    The filter appears in the project window. You can rename the filter now or later.

  3. Specify the Usage property for the filter.
    • When you select Always, the filter is applied to all objects in the dimension or query subject.
    • When you select Security, the filter is used to define data security.
  4. In the project pane, double-click the filter to open the expression editor and specify the filter expression.
    If the expression is complex, you can use an external editor to edit the expression and then copy it to the Specification tab.
  5. On the Issues tab, check for possible errors in the expression, and resolve the errors.