Skip to Content
Author's profile photo Kodanda Pani KV

Calculation After and Before Aggregation

     How to calculate the total amount before and after aggregation?

Product name, quantity and amount
defining the formula at local level

Total amount= product quantity x amount

It will give out put like means total amount not yet aggregated it is giving product quantity x product price = total amount

Now report output but achievement total amount should be aggregated value.

Creating global level calculated key figure

Creating KF at Global level

Here not using exception aggregation

This Total amount KF defined at global level

global level calculated KF will appear the calculation after aggregation

Output should be below report

Output of the report now showing total amount was aggregated

Now report out put total amount is given aggregated value.

hope it will help beginners.

Assigned tags

      21 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Good job! 🙂 And what means warning about obsolete time of calculation?

      Author's profile photo Phani KV
      Phani KV
      Blog Post Author

      Hi Pocket,

      defined the global level calculated KF and performing after and before aggregation. that is warning msg and i am not defined the KF technical name.

      Thanks,

      Phani.

      Author's profile photo Former Member
      Former Member

      Thanks, Phani.

      May I ask you a question? If this is obsolete method what is up-to-date one for this case? Spec. aggregation?

      Author's profile photo Anshu Lilhori
      Anshu Lilhori

      You can check the note which i mentioned and also the way which needs to be used for handling such scenarios.

      Author's profile photo Former Member
      Former Member

      Thanks! You are ahead of me with the answer. 🙂

      Author's profile photo Anshu Lilhori
      Anshu Lilhori

      Before aggregation is obsolete in BW 7.X and it can actually drain the system resource thereby causing performance issues.

      Please check this note 1151957.

      Exception aggregation or calculate result as total should be used in such scenario.

      Author's profile photo Former Member
      Former Member

      Thanks, Anshu! That's it! 🙂

      Author's profile photo Phani KV
      Phani KV
      Blog Post Author

      Thanks a lot Anshu Giving information it is helpful for us.... 🙂 🙂 🙂

      Author's profile photo Chandra Janardhansudhir Kunar
      Chandra Janardhansudhir Kunar

      Hi Anshu,

      I have few queries with this error message( calculation prior to aggregation not allowed ). Should i just check this box for each key figure, or need to make any other changes?

      Thanks & regards,

      Sudhir.

      Author's profile photo Former Member
      Former Member

      Good 🙂

      Author's profile photo Wasem Hassan
      Wasem Hassan

      simple but best doc

      Thanks for sharing..

      keep it up.. 🙂 🙂

      Regards

      Wasem

      Author's profile photo Satendra Mishra
      Satendra Mishra

      Nice document 🙂 bookmarked it.

      Regards,

      SM

      Author's profile photo Former Member
      Former Member

      Nice doc.

      Author's profile photo Phani KV
      Phani KV
      Blog Post Author

      Thanks Bindu Your comment...

      Author's profile photo CH Raman
      CH Raman

      Hi,

      Good presentation and thanks for letting know about obsolete function on 7.x bex feature.

      Thanks

      Author's profile photo Phani KV
      Phani KV
      Blog Post Author

      Thanks for your feed back 🙂 🙂 🙂 .

      Author's profile photo Nitesh Kumar
      Nitesh Kumar

      Hi Pani,

      Very nice document with great explanation.

      Good job 🙂 .

      Regards,

      Nitesh

      Author's profile photo Phani KV
      Phani KV
      Blog Post Author

      Thanks for your comment Nitesh.

      Author's profile photo Former Member
      Former Member

      Great job done on before and after Aggregation. 🙂 .

      Author's profile photo Phani KV
      Phani KV
      Blog Post Author

      Thanks for your comment.

      Author's profile photo Former Member
      Former Member

      Nicely explained document. Thanks for sharing kodanda 🙂