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

If i change a CKF in BEx, does the changed formula will get auto updated in all sections?

Hi All,

I want to change a existing CKF, it is used in most of the queries, my question is does the changed CKF will get auto updated in all the formula selections where ever this CKF used or should i need to manually update the changed CKF.

My understanding is if i change a CKF , the changed formula will get updated in all the BEx queries where ever it is used,please suggest.

Regards,

Sharath

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Best Answer
    Posted on Jul 06, 2016 at 05:24 PM

    Hi Sharath,

    The answer is ... may be.

    For a definitive answer, one needs to understand the the difference between a formula and a "true " calculated key figure. The terms are commonly interchanged. It also doesn't help that they are both started the same way - in the formula function.

    Formulas exist only in the query, and are not reusable.

    If you save a formula with a technical name, it becomes a reusable object tied to the InfoProvider which can be used in multiple queries - a calculated key figure.

    If a calculated key figure is changed, the change applies across all uses.

    Look for a technical name in Query Designer in the formula to determine if it is a formula (single query only) or a calculated key figure. (reusable object.

    Please don't forget to record your final solution and to mark the question as answered.

    Good luck,

    John Hawk

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 07, 2016 at 09:03 AM

    HI Sharath,

    If you change CKF it will impact other queries too.

    If you want to change CKF in other queries then go for 'Formulae'.

    regards,

    Siva Krishna.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 08, 2016 at 09:25 AM

    Hi Sharath,

    Any change in any reusable element of a query(CKF, RKF, Structure, Variable etc) will automatically reflect wherever it is being used. No manual action is required .

    Regards,

    Uthaya

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 11, 2016 at 01:17 PM

    use remove reference

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 18, 2016 at 11:23 AM

    Change in CKF reflected in all Queries, thank you for your assistance

    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.