Exception Aggregation

[Former Member]

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]

Hi PVK,

Look at business content datasource 2lis_13_vditm ( Billing Item details ) , it will give you exactly the data (net value etc) required by you . Create cube based on this datasource instead of going through invoice conditions .

Hope that helps.

Regards

Mr Kapadia

[Former Member]

Hi,

If you are using BI 7, create a formula which will have only Net sales in it and give the exception aggregation as 'Total' and the reference characteristic as 'Billing item' for the formula. Hope it will give you the correct result.

Regards.

Edited by: vinay kasa on Sep 10, 2008 5:37 AM