Hello Guys,
I have the following scenarion in BW.
1. Cumulative Key figure(KF) with Aggregarion as "Maximum", Exception aggregation as "Summation" on characteristics "B"
2. I have the following data at DSO1 where A and B are the key.
A B D E KF
A1 B1 D1 E1 100
3. I am multiplying the base data with anothe characteristics(C) value as below in DSO2.
A B C D E KF
A1 B1 C1 D1 E1 100
A1 B1 C2 D1 E1 100
4. The same data goes to Cube as follow.
A B C D E KF
A1 B1 C1 D1 E1 100
A1 B1 C2 D1 E1 100
5. The report output with characteristics A and KF in the view is as follow which is perfectly fine.
A KF
A1 100
6. But the key figure value doubles when an delta record comes to cube. Say D1 is changed to D2.
A B C D E KF
A1 B1 C1 D1 E1 100
A1 B1 C1 D1 E1 -100
A1 B1 C1 D2 E1 100
A1 B1 C2 D1 E1 100
A1 B1 C2 D1 E1 - 100
A1 B1 C2 D2 E1 100
7. The report output becomes as below, which is wrong.
A KF
A1 200
8. Ideally it should still show as below as the key figure is an exception aggregation with reference characteristics "B".
A KF
A1 100
I did som initial investigation and found that, since aggregation is "Maximum", the before and after image are not cancelled out. It takes the maximum of 100 and -100 values as 100.
Can you please provide your expert suggestion about how to overcome this issue?
Thanks & Regards,
Rajib