Skip to Content
0
Former Member
Feb 23, 2006 at 07:18 AM

AGGREGATION PROBELM..in BEX

18 Views

Hi All,

I have PO items under Pur doc. No in cube.

In Cube:

Contarct Pur doc. No Pur doc.Item ZCum.Pln.Val

100 50000 10 40k

100 50000 20 40k

100 50000 30 40k

100 50001 10 40k

100 50002 10 40k

100 50002 20 40k

In Report I want to see : (over all picture i.e Client needs without Po items & Doc_numbers)

100 50000 40k

100 50001 40k

100 50002 40k

But it shows NOW :

100 50000 120k ( It is summed up , WRONG VALUE)

100 50001 40k (Right value)

100 50002 80k ( It is summed up , WRONG VALUE)

In RSA1 --> Zcum.pln.val Key Figure info object’s AGGREGATE Tab properties are:

Aggregation : SUM

Exception Aggregation: Summation.

Cummulative value option is also selected.

1. What changes shall I do, to get my required result in RSA1- infoobject properties.? Pls. advise step wise.

2. If I change properties to this Zcum.pln.val object , Will it effects to existing Cube data?

3. without changing properties to this Zcum.pln.val object, what options shall I use in BEx level, to get required result.

Please help me and tell step wise.

Thanks & Regards,

siri