Configure a measure filter

You can build a filter expression for the aggregate calculations to select a subset of the transformed data from external data sources and populate the measure table in the datastore. You can configure only one filter per aggregate calculation.

For more information about aggregate calculations, see Configure an aggregate calculation.

You can build a filter expression by using the dimension fields and the expression operators.

Configure a measure filter

1. Open the AVEVA BI Gateway Model Builder.

2. Click the Add icon in the Fast Action Buttons menu and then click the Measure icon. A new measure is added in the AVEVA BI Gateway model with a default name and the Measure editor appears in the right pane.

3. Click the Edit Calculations button. The Context & Calculations page appears.

4. In the Context & Calculations page, click a required aggregate calculation.

5. In the Calculations area, click the required aggregate calculation.

6. Click Expand to expand the Filter expression editor.

   Note: You can click Collapse to collapse the Filter expression editor.

7. In the Available aggregates area, click the aggregate calculation for which you want to configure a filter.

8. Build a filter expression. Do the following:

   • In the Available context Filter Expression, specify an expression operator to add to the Filter Expression editor.

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

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

9. Click the Validate button to manually validate the expression syntax.

   Note: Alternatively, the system automatically validates the expression syntax after you save the measure.

10. Click Save.