You can add one or multiple filter criteria to filter the values of the PPM query.
Procedure
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).
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.