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

[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