Skip to Content

BEx: deletion of local formulas deletes definition of calculated key figures

Hi all,

During our BEx query devlopment process we are encountering the following - quite annoying - issue:

* we make a copy of an existing BEx query (query <x>) for testing purposes

* query <x> contains calculated and restricted key figures (defined on the Infoprovider)
* in this copied query - query <y> - we create a local formula

* in this local formula we use an existing calculated key figure <ck1>

* after testing we delete this local formula in query <y>
* when opening original query <x> it appears that calculated key figure <ck1> is not usable anymore in query <x> because the definition of <ck1> is gone / has been erased!

The only way to restore this is to manually redefine the <ck1> formula.

This issue is very tricky because of you are not careful and put a new version of query <x> to production it cannot be executed anymore (error message on incorrect key figure definition)

Has anyone encountered this issue?

And if so did you find a solution for this?

Thanks a lot!



Our environment: SAP BW 740, SP13 / BEx query designer 740, SP0, revision 739

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Aug 24, 2016 at 07:19 AM


    A quick update:
    We implemented OSS note

    1989353 - Calculated Keyfigures (CKF) definition lost

    This implied that we upgraded the BEx query designer 740 from:
    SP0, revision 739
    to: SP5, Patch 1, revision 773

    Since the upgrade of this BI AddOn 7.40 we haven't encountered the abobve mentioned issue



    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.