Filter values in floating point number format are made up of a decimal number with any number of decimal places and an optional unit and must be specified as an interval. One interval can be specified for each parameter.
A floating point number is specified on a country-specific basis, and the sign can be omitted for positive values. The decimal places are separated by either a comma or a point. The number format is specified after the keyword in round brackets in accordance with the following syntax: Key(<Thousands separator><Decimal separator>)
You can set the number of decimal places displayed in the PPM user interface in the client-specific configuration file Keyindicator_settings.properties using the keys MINIMUM_FRACTION_DIGITS and MAXIMUM_FRACTION_DIGITS.
If the floating point number is based on a dimension or measure with a unit (scaling), the filter value must be specified with a unit. The unit must be separated from the number by a space.
Closed intervals
A closed interval is specified by two values separated by a separator (see chapter on Transfer of filter values).
Example
For the Process cycle time measure, a filter is set which calculates only measure values between 10.5 and 12.5 days (>= 10.5 days and <12.5 days):
PDLZ(.,)=10.5 DAY-12.5 DAY
or
PDLZ(.,):to=10.5 DAYto12.5 DAY
The point is specified as the thousands separator, the comma as the decimal separator and Day as the unit.
To enter negative values, you must use a user-defined separating string, otherwise the sign will be interpreted as the default separator (minus sign).
Open intervals
An open interval is specified by a single value followed by a separator. The separator determines the nature of the interval. The following codings must be used as separators:
Interval |
Coding |
Description |
< |
lt |
All values that are less than the specified numerical value are taken into account. |
<= |
le |
All values that are less than or equal to the specified numerical value are taken into account. |
> |
gt |
All values that are greater than the specified numerical value are taken into account. |
>= |
ge |
All values that are greater than or equal to the specified numerical value are taken into account. |
Example
Parameter specification for the Order volume measure in American format:
ORDERVOL(,.):gt=1,239,157.45
After the keyword ORDERVOL for filter criterion Order volume, the thousands separator is specified first in round brackets, followed by the decimal separator. All measure values greater than 1,239,157.45 are displayed. There is no unit, as the Order volume measure is based on an attribute of the no-unit data type DOUBLE.