Data Source Filter Reference

When creating a plan from a data source, you can configure dimension filters that are applied to the dataset. A filter condition consists of three parts:

  • Dimension - the dimension whose values you want to filter.
  • Operator - the operator used when filtering. For more information, see Data Source Filter Operators.
  • Value - the dimension value used when filtering.

Operators

Here are the operators available when defining a dimension filter.

Data Source Filter Operators
Operator Description
Equals Returns dataset rows that contain any of the selected dimension values. You can select multiple values.
Not Equals Returns dataset rows that do not contain any of the selected dimension values. You can select multiple values.
Contains Returns dataset rows whose dimension values contain the introduced value.
Not Contains Returns dataset rows whose dimension values do not contain the introduced value.
Start With Returns dataset rows whose dimension values start with the introduced value.
Is Null Returns dataset rows whose dimension values are null, meaning that they do not contain a value.
Is Not Null Returns dataset rows whose dimension values are not null, meaning that they contain a value.

Filter Logic Options

Here are the filter logic options available when defining the filter configuration for a plan created from a data source or a template.

Filter Logic Options
Option Description
All Conditions are Met (AND) Returns data that matches all selected values.
Any Condition is Met (OR) Returns data that matches any of the selected values.