Skip to Content
0
Former Member
Jan 05, 2012 at 06:47 AM

Problem with Cumulative Key figure With Exception Aggregation

10 Views

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