Configuring a Filter for a Dimension

You can build a filter expression to select a subset of the transformed data from external data sources and populate the dimension table in the data store. You build a filter expression by using dimension fields and/or expression operators.

To configure a filter for a dimension

1. Open the BI Gateway Model Builder.

2. Click the Add () icon in the Floating Action Buttons menu and then click the Dimension () button. A new dimension is added in the BI Gateway model with a default name and the Dimension editor appears in the right pane.

3. Click the Filter tab.

   

4. Build a filter expression. Do the following:

   1. In the Dimension Fields pane, double-click the dimension field to add the dimension field to the Filter Expression editor.

   2. Specify an operator to add to the Filter Expression editor.

      You can use the open and close parenthesis () to define sub-comparison expressions and single quotes '...' as string delimiters. The filter expression needs to be a valid SQL Server WHERE clause.

      For more information about WHERE clauses, see the Microsoft SQL Server documentation.

5. Click Validate to manually validate the expression syntax.

   NOTE: Alternatively, the system automatically validates the expression syntax after you save the dimension.

6. Click Save.