Exception Aggregation Not Working

[former_member182997]

Dear Experts,

I have created a report for billing document details. In the report I have finding the exception aggregation for some billing documents are not working.
Would you please suggest me how can i solve this issue?

At Cube level:

I am using exception Aggregation average with condition type
desired value  is 20,000 but it is showing 21.818 which is wrong.

At Report Level:

Can you please suggest why exception aggregation is not working  here.

Best Regards

[anshu_lilhori · Accepted solution]

I just had a close look to your data and got the problem..

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.

Total count of unique condition type is 11 so the calculation becomes 240000/11 = 21818.18

Hope this explanation gives you an idea to get the workaround for proper result.

Regards,
AL

[former_member182997 · Accepted solution]

Superb

Thank you so much for correcting me.
So what do you think should be my approach?  Actually almost all the billing docs are getting correct billed quantity display as condition type is unique in each row.
But few documents like the one in the screenshot is having problem.

Would you like to suggest few ideas? And thank you once again...for showing me the problem.
You are too good! 

Regards,
Aparajit

[KodandaPani_KV]

Hi,

use the aggregation type - counter for all values that are null or zero.

reference char -> condition type.

put the condition type in free char panel.

after try the result bex analyzer and RSRT.

Thanks,

Phani.

[former_member182997]

Hi  kodanda pani KV

thanks for your reply. I have tried counter. But no luck.
but counter will not  give the display of billed quantity isn't it?
only option i find is average of all the values to pick a unique vale and get it displayed in result.

Your thoughts please!

Thank you so much

[Former Member]

Hi ,

when you run your query the values get aggregated according to the characteristics  and then exception aggregation takes place , this may be reason that you Exception agg, is not working .

You either have to use the char in query also or use summation function for keyfigure.

Regards,

Abhishek Bhattacharya

[former_member182997]

Hi Abhishek
Thanks for reply. I have used the char as free characteristic in the query and used  exception aggregation for the KF  in question. But no luck.

Any idea?

Regards,
Aparajit

[Loed]

Hi mate,

Did you try AVERAGE OF DETAILED VALUES THAT ARE NOT ZER, NULL, OR ERROR?

Is CONDITION TYPE not really included in the report?

Loed

[former_member182997]

Dear Loed,
I tried your suggestion. I am using condition type as a free characteristic in my query.
But for this billing doc EA is not working properly. instead of 20,000 it is giving 21.818

Any other ideas mate..

-aparajit

[Former Member]

Hi,

Kindly check the actual definition of the key figure in the Data Modelling(RSA1). That might be causing the issue.

We have to define the exception aggregation for the key figure in backend.

Regards,

Priyanka

[former_member182997]

Hi Priyanka,
If that is the case then i must have got the same mismatch for all the billing doc and not few only.
The problem i am facing is exception aggregation not taking place for the above billing doc and two more.
But  for others its totally good.

Any other ideas?

Thanks!
Aparajit