Skip to Content
author's profile photo Former Member
Former Member

Problem with automatic convertion of calc KF from Before agg to After agg

Dear Team,

We have done BI upgradation from BW 3.1 to BI7. Now we are migrating the queries. In some of the BW 3.5 queries we have used calculated key figure which contain before aggregation. We have taken copy of that BW 3.5 query, created new calculated keyfigure with exception aggregation and saved in BI7. After that BI7 query showing that new calculated keyfig value fine but whatever other 3.5 calc keyfig which are used in this BI7 query which contain before aggregation earlier in 3.5 automatically converted to after aggreagation. This is a big problem for us now. If anybody faced this problem pls reply, its urgent...........

We have checked forum and SAP Notes but couldnt find solution for this type of problem

Best Regards,


Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Oct 23, 2007 at 09:45 AM

    Hello SG,

    This is a pretty newly found problem is the frontend coding of Query Designer 2004s. When you save a 3.x query with 'calculation before aggregation' this property is lost in QD and nothing saved into db.

    The bug is fixed already with revision 511 (and higher). But at the moment there is no hotfix available. So most likely it will go into FrontEnd Patch 16.

    There are, in principle, way how to manage this property manually directly in the tables, but tI would recommend a message for this ...

    Best regards,


    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.