Question Re: Exceptional Aggregation Problem in Technology Q&A

Exceptional Aggregation Problem

aditya_bakshi — Fri, 08 Aug 2014 11:18:40 GMT

Hi My data is like this:

PO Quantity

1 10000

10000

7000

2 7000
7000

7000

3 7000

7000

What i want is like this.

PO Quantity

1 17000

2 7000

3 7000

How can it be done in BEx????

Thanks

Re: Exceptional Aggregation Problem

anshu_lilhori — Fri, 08 Aug 2014 11:21:23 GMT

First let me know how are you getting more than one Qty against one PO.There might be other characteristic involved which will be making unique row.

Please check.

Regards,

Re: Exceptional Aggregation Problem

aditya_bakshi — Fri, 08 Aug 2014 11:28:42 GMT

Yes we have condition type wise date.But in one report i dont want summarized data.

PO	GR	Quantity	Condition Type
1	11	10000	AA
1	11	7000	BB
2	12	7000	AA
2	12	7000	CC
3	13	7000	BB
3	13	7000	CC

Now when i remve condition type it aggregates all quantties.So what i want is that for GR 11 Quantity should be 17000,for GR 12 Quan. should be 7000 and for GR 13 Quan. should be 7000.Is this possble????

Re: Exceptional Aggregation Problem

anshu_lilhori — Fri, 08 Aug 2014 11:43:03 GMT

Ok you need to make use of Nested exception aggregation..

Make a new formula--Put your Qty keyfigure inside it--Hit the aggregation tab--Exception aggregation as first value--Reference characteristic as condition type-

Now create another formula and put the last formula inside it--Again hit the aggregation tab--Exception aggregation as first value--Reference characteristic as PO-

Hope this works.

Regards,

Re: Exceptional Aggregation Problem

aditya_bakshi — Fri, 08 Aug 2014 11:53:54 GMT

No It only displays the first value.Output is like this.

PO	GR	Quantity
1	11	10000
2	12	7000
3	13	7000

GR 11 should be 17000 not 10000.Any suggestions??

Re: Exceptional Aggregation Problem

anshu_lilhori — Fri, 08 Aug 2014 11:58:36 GMT

I think you need to analyze the data properly..still some char must be there which will give unique record because for PO1 you are getting different qty values and for PO2 same quantity values

Check that.

Regards,

Re: Exceptional Aggregation Problem

Former Member — Fri, 08 Aug 2014 12:44:01 GMT

Aditya,

Do Everything Anshu ssuggested except change the Exception aggregation to Average. This should fix it.

Regards

-Sid

Re: Exceptional Aggregation Problem

Former Member — Fri, 28 Nov 2014 04:37:29 GMT

See in exception aggregation you always have to choose the reference characteristic which has unique values.

In your case you choose reference characteristic as condition type.Check ZFRP it is repeated so while taking average it is considered as 1 not 2.

check out this link for steps and screenshots of how to do this:

http://sap.learnatonce.com/Use-Exception-Aggregation.php

regards

Re: Exceptional Aggregation Problem

KodandaPani_KV — Fri, 28 Nov 2014 04:51:01 GMT

HI,

first check the any object like any date fields or any other object giving the unique vlaues.

go to the cube -> download the some data with all fields records(10-15) -> check the any obejct have unique values.

based on the unique vlaues apply the exception aggregtion based on the char.

Thanks,

Phani.