Examples: Aggregations and Validity

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

Validity and Exception Aggregation AV1

Filter: Non-cumulative value with AV1, Plant = A,B
Month/plant	A	B	Total
January	250		250
February	250	330	580
March	350	330	680
April		370	370
Total	284,44	343,48	627,93

The time filter is determined from the merge of the validities of plants A, B. For exception aggregation AV1, no values are determined outside the validity.

Validity and Exception Aggregation MAX

Filter: Non-cumulative value with MAX, month in [January - March], plant = A,B
Month/plant	A	B	Total
January	250	[300]	550
February	250	330	580
March	350	330	680
Total	350	330	680

The time filter is determined from the global filter [January - March] and intersected with the merge of the validities of plants A,B ([January - April]). For plant B, the value for January, which is outside the validity, is added.

Validity and Exception Aggregation FIRST

Filter: Non-cumulative value with FIRST, month in [January - June], plant = A,B
Month/plant	A	B	Total
January	200	[300]	500
February	250	300	550
March	250	330	580
April	350	330	680
May	[350]	[370]	[720]
Total	200	300	500

The time filter is determined from the global filter [January - June] and intersected with the merge of the validities of plants A,B ([January - May]) that have been extended at the end because of the FIRST aggregation . For plant B, the value for January, which is outside the validity, is added. The value for May is added for both plants. For plant B, the value for May is different to the value for April, as there was no non-cumulative change yet in April, and initial non-cumulatives are displayed with FIRST aggregation.