Examples: Validities and Constant Selection

Concept

For cells with constan selection, a separate validity range is found. The examples below illustrate this.

Dataset:

Plant	Initial non-cumulative
A	200
B	300
C	400

Plant	Month	Non-cumulative change
A	January	50
A	March	100
B	February	30
B	April	40
C	March	30
C	May	30

Plant	Validity
A	January - March
B	February - April
C	March - May

Example 1:

Filter: Plant = A
Month	Non-cumulative with LAST	Non-cumulative with LAST, plant = B, constant selection on plant
January	250	[300]
February	250	330
March	350	330
Total	350	370

The validity for the part of the query without constant selection is the validity of plant A [January - March]. This results in the times that are visible in the drilldown. The validity for the part of the query with constant selection is the merge of the validities of plants A,B [January - April]. A value for January is therefore displayed for the second structure element. The value for the second structure element in the totals row arises from the non-visible value for plant B in April.

Example 2

Filter: Plant = A
Month	Non-cumulative with LAST	Non-cumulative with LAST, plant = B, constant selection on plant, month = May	Non-cumulative with LAST, plant = C, constant selection on plant
January	250		[400]
February	250		[400]
March	350		430
Total	350	[370]	460

The validity for the part of the query without constant selection is the validity of plant A [January - March]. This results in the times that are visible in the drilldown. The validity for the part of the query with constant selection is the merge of the validities of plants A,B,C [January - May]. A value is therefore displayed in the totals row for the second structure element. The value for this structure element in the totals row arises from the non-visible virtual value for plant B in May. If structure element three did not exist, this value would not be displayed. The value for the third structure element in the totals row arises from the non-visible value for plant C in May.