Add filter

You can add one or multiple filter criteria to filter the values of the PPM query.

Procedure

  1. Click Add filter.
  2. Select a Dimension or Measure provided by PPM, for example., date or process throughput time, and click Add. The selected criterion is added to the PPM operator.
  3. Select an operator for the condition of the filter criterion in the drop-down menu, for example, is equal to.
  4. Enter a constant filter value in the input field or insert an input parameter by clicking Insert parameter Insert input parameter. The button is only clickable if there is at least one input parameter with the same data type.
  5. Click the Set filter properties icon and specify the criterion parameters.

    When specifying parameters, such as filter criterion and filter values, follow the predefined syntax of the PPM query interface (query API). See example below. For detailed information on the PPM query interface, refer to the PPM documentation PPM Query interface.

    Filter using an expression uses criterion expressions for filtering. This option is available for criterions of data type text.

    Key uses the criterion key as a filter value.

    Description uses the criterion description as a filter value.

    Set filter level allows the selection of the level you want to filter. This option is available for two level and multi level dimensions.

    Example: The two level dimension Dealer with the levels Region and City allows you to filter the data according to Region or City.

    Scaling. This option is available for criterions of data type date and for some numeric data types (for example, a numeric or percentage KPI value).

  6. Click Add filter Add condition to add further filter conditions.
  7. Click Next to close the dialog.

Your settings are applied.

Example

The result of the PPM query depends on the syntax used in the PPM query interface. The character combination of space + ( in the filter value (for example, ABC (123)) can lead to different results, depending on the filter criterion.

If you filter for "SOLDTO_NAME=ABC (123)", PPM searches for the customer with the name = "ABC" and the description = "123".

If you filter for "SOLDTO_NAME(VAL)=ABC (123)", PPM searches for the customer name "ABC (123)" and does not take the description into account.

If you filter for "SOLDTO_NAME(DESC)=ABC (123)", PPM searches for the customer whose description is "ABC (123)" and does not take the name into account.