Show TOC

# 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.