Question Re: Exception Aggregation Not Working in Technology Q&A

Exception Aggregation Not Working

Former Member — Fri, 10 Oct 2014 06:45:58 GMT

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

Re: Exception Aggregation Not Working

Former Member — Fri, 10 Oct 2014 07:06:40 GMT

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

Re: Exception Aggregation Not Working

Loed — Fri, 10 Oct 2014 07:11:43 GMT

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

Re: Exception Aggregation Not Working

Former Member — Fri, 10 Oct 2014 07:29:26 GMT

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

Re: Exception Aggregation Not Working

KodandaPani_KV — Fri, 10 Oct 2014 07:41:35 GMT

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.

Re: Exception Aggregation Not Working

Former Member — Fri, 10 Oct 2014 09:17:29 GMT

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

Re: Exception Aggregation Not Working

Former Member — Fri, 10 Oct 2014 09:19:14 GMT

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

Re: Exception Aggregation Not Working

Former Member — Fri, 10 Oct 2014 09:23:05 GMT

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

Re: Exception Aggregation Not Working

Former Member — Fri, 10 Oct 2014 09:27:40 GMT

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

Re: Exception Aggregation Not Working

anshu_lilhori — Fri, 10 Oct 2014 10:03:12 GMT

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

Re: Exception Aggregation Not Working

Former Member — Fri, 10 Oct 2014 10:16:37 GMT

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