cancel
Showing results for 
Search instead for 
Did you mean: 

Result & Overall Result of report is incorrect in Bex Analyser

Former Member
0 Kudos
849

Hi Experts,

I have designed the stock ageing report and individual values are coming fine in the report but overall result is showing wrong values with large difference. the report in the production system.

Can any one give me the solution.

Regards,

Satya

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Satya,

when you say wrong value, what is the issue?

If you expect to have the overall result as addition of all the values then in the query designer for particular key figure go to the properties and check what is the aggregation method selected. It needs to be 'SUM' for getting the overall result as summation.

Regards,

Durgesh.

Answers (1)

Answers (1)

anindya_bose
Active Contributor
0 Kudos

Hi Satya

For the Result you have formula or CKF?

Try creating a CKF and use the option "Calculation After Aggregation" ..

You can try other options also to check which one is bringing correct information.

By the way, your cube is non-cumulative or snap-shot scenario based on exceotion aggregation?

Have a look at the below thread..this might be helpful

http://help.sap.com/saphelp_nw04s/helpdata/en/d2/02223c5f00612be10000000a11402f/content.htm

Regards

Anindya