If planned values are shown in the analysis, one planned value is displayed for each data point.
It is identified as follows.
1. First of all, all planned value definitions defined for the measure represented in the analysis are determined for each data point.
Example
For the current query, the Process cycle time measure, the Cash sale process type and a CW 46/2002 filter are set. For the Process cycle time measure displayed, the following planned value definitions are determined:
No. |
PTG/PT |
Measure |
Filter |
Filter value |
Planned value 2 |
---|---|---|---|---|---|
1 |
Credit memo |
PDLZ |
Time |
Nov. 2002 |
3.000 day(s) |
2 |
Order |
PDLZ |
Time |
Nov. 2002 |
1.800 day(s) |
4 |
Returns |
PDLZ |
Time |
2002 |
2.000 day(s) |
5 |
Cash sale |
PDLZ |
Time |
Nov. 2002 |
1.500 day(s) |
8 |
Cash sale |
PDLZ |
Time |
Dec. 2002 |
1.300 day(s) |
11 |
Cash sale |
PDLZ |
Time |
2002 |
1.300 day(s) |
2. From all the relevant planned value definitions, those definitions matching the queried process type are then determined. If there are no planned value definitions for the process type, all planned value definitions of the higher level process type group are determined.
Example
In the example, the planned value definitions 5, 8, and 11 are determined:
No. |
PTG/PT |
Measure |
Filter |
Filter value |
Planned value 2 |
---|---|---|---|---|---|
5 |
Cash sale |
PDLZ |
Time |
Nov. 2002 |
1.500 day(s) |
8 |
Cash sale |
PDLZ |
Time |
Dec. 2002 |
1.300 day(s) |
11 |
Cash sale |
PDLZ |
Time |
2002 |
1.300 day(s) |
3. From these planned value definitions, all planned value definitions that have the highest number of filter criteria are then determined.
In the example, all three planned value definitions previously determined have the same number of filter criteria, which means that the selection cannot be limited any further.
4. If several planned value definitions were determined in the previous step, a ranking is created based on the deviation in the resolution of the filters specified in the analysis and the planned value definition. The most specific planned value definitions are those with the lowest deviation.
Example
In the example, planned value definitions 5 and 8 are determined because the deviation in the resolution of the filter used in the analysis (week) and the resolution of the filter specified for the planned value (month) is one level in each case.
No. |
PTG/PT |
Measure |
Filter |
Filter value |
Planned value 2 |
---|---|---|---|---|---|
5 |
Cash sale |
PDLZ |
Time |
Nov. 2002 |
1.500 day(s) |
8 |
Cash sale |
PDLZ |
Time |
Dec. 2002 |
1.300 day(s) |
5. If several planned value deviations with the lowest overall deviation were determined in the preceding step, the planned value definition with the most critical planned value is determined. The most critical planned value means the highest planned value for positively assessed measures or the lowest planned value for negatively assessed measures.
Example
From the example data, planned value definition 8 is determined and displayed at the data point in the analysis.