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.
Edited by: PVK on Sep 9, 2008 12:45 PM