Exception aggregation

[Former Member]

Hello all,

I have a problem with my query, i don't want to aggregate on a characteristic, i've tested many options by creating a formula with my characteritic and tried with several possibilities on exception aggregation but none is working.

If someone can help me.

Thank you by advance.

[Former Member]

Pls refer this link to understand exception aggregation with example.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/f0b8ed5b-1025-2d10-b193-839cfdf73...

Pls assign points if it was useful

[Former Member]

Any help ??? please

[anshu_lilhori]

Hi,

Can you please paste the sample output of the report so as to understand what exactly is the requirement.

Regards,

AL

[Former Member]

hello, here my report result:

Division Material Qty mouvement mouvement value Coût matière standard lot

1000 HB9754 2 250 EUR 200EUR

and i would like to obtain :

Division Material Qty mouvement mouvement value Coût matière standard lot

1000 HB9754 1 150 EUR 100EUR

1000 HB9754 1 100 EUR 100EUR

If you have more questions don't hesitate.

thanks by advance.

[Former Member]

now the question is that is the query based on an DSO or cube? can you see single or double reocrds in the data target as well or no?

[Former Member]

It's based on cube, and i have the 2 records in this cube. Only the query agregates.

[Former Member]

you could do 1 thing. create an infobject name bcounter or wht your company naming convention is and make it constant in the cube and make it 1 in the transformation or trnafer rules..reload data..now add the field to your key figures in query but keep it hidden. that should help show 2 fields.. or try moving the fields around from filter and rows to see if it removes aggregation.

[Former Member]

It's not working

[anshu_lilhori]

Hi,

Its a normal behavior of OLAP if all the characterstics are same then the value of two keyfigures are added.

You need to have some unique char which actually tells system that they are distinct record

In cube it will be two different record because they must be seperated by request id.

Moreover you need to check the data of cube there must be some characterstic which diiferentiated the two records.If that is not the case then as i said earlier it must be differntiated on request id.

Same way in report you can select request id from data pacakge and put it in rows and then you can hide the display of it.

Hope it helps.

Regards,

AL

Edited by: AL1112 on Dec 9, 2011 6:21 AM

[Former Member]

It worked, thank you very much.

[anshu_lilhori]

Hi,

Please close the thread if your issue is resolved.

Regards,

AL