Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Exception Aggregation

Hi Guys,

We do have a issue with Exception aggregation. I did look for old SDN posts but didn't find a solution.

We do have data coming from 2LIS_13_VDKON into DSO.

Data looks like this

Billing Doc Billing item Cond counter Net value

9000001 10 1 $10

9000001 10 2 $10

9000001 10 3 $10

As shown above Billing doc/Billing Item combination can have any number of counter values but Net value is per billing item. In the cube we don't have Condcounter and to make sure Net value is not aggregated per billing item( In this case it should show $10 instead of $30), On Net value key figure i had a exception aggregation, with Normal aggregation as 'MAX' and Exception as 'Summation' with refer char of Billing item.

When we load the data into the cube it is working fine.

In the cube data looks like this :

Billing Doc Billing item Net value

9000001 10 $10

In the report we don't have Billing item in the layout and the results are unpredictable.

If have exception aggregation on the InfoObject , do we defnitley need to have the reference char in the report Layout. We can't have Billing Doc/Billing Item in the report as the volume of data will be very high.

Please do advise any solution.

Thank you,

PVK

Edited by: PVK on Sep 9, 2008 12:45 PM

Former Member
Not what you were looking for? View more on this topic or Ask a question