In case of filter (default filters or fixed values in BW Queries) or restrictions in Restricted Key Figures or locale selections you find a operator in the XML file (see example). This page will give you a translation of the operators.
The first 2 characters of the operator are 'I_' or 'E_'.
-
'I_' means - 'Select specific values'
-
'E_' means - 'Exclude specific values'
From the example above the E_EQ has the same meaning as I_NE.
|
Operator |
Meaning |
|---|---|
|
EQ |
Equal: Single Value |
|
NE |
Not Equal: Everything Apart from the Specified Single Value |
|
BT |
Between: Range of Values |
|
NB |
Not Between: Everything Outside the Range |
|
LE |
Less or Equal: Everything <= Value in Field LOW |
|
GT |
Greater Than: Everything > Value in Field LOW |
|
GE |
Greater or Equal: Everything >= Value in Field LOW |
|
LT |
Less Than: Everything < Value in Field LOW |
|
CP |
Contains Pattern: Masked Input: Find Pattern |
|
NP |
Not Contains Pattern: Masked Input: Reject Pattern |