Creating a dynamic subset

To create a dynamic subset, select Dynamic subset and click Next.

Select the check box Edit filter definition. Click Yes. Specify the SQL statement in the Filter definition text field.

Or:

Click Filter. Specify the filter definition in the Filter Dialog. If you select No filter (select all elements), all elements of the dimension are taken into the subset. If you select Filter by, you may specify the elements of the subset by defining the filter. Specify the Column, Operator and Value of a filter definition. You may create several filter definitions and combine them by logical operators AND or OR. To delete a filter definition, click Delete Filter.

The SQL statement of the filter definitions is displayed in the Filter definition field of the Subset Wizard and can be edited there.