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,

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