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

[former_member1153184]

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!

Cheers,

Marc

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

[former_member1153184 · Accepted solution]

Hi,

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

Regards,

Marc