Exceptional Aggregation Problem

[aditya_bakshi]

Hi My data is like this:

PO     Quantity          

1        10000

          10000

            7000

            7000

2        7000
          7000

          7000

3        7000

          7000

          7000

What i want is like this.

PO     Quantity          

1        17000            

2        7000
          

3        7000

How can it be done in BEx????

Thanks

[anshu_lilhori]

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,

AL

[aditya_bakshi]

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????

[anshu_lilhori]

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,

AL

[aditya_bakshi]

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??

[anshu_lilhori]

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,

AL

[Former Member]

Aditya,

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

Regards

-Sid

[KodandaPani_KV]

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.