Skip to Content
avatar image
Former Member

difference between Formula and CKF

may I knoww difference between Formula and Calculated Keyfigure ..

Thankks in advance

Kris

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • avatar image
    Former Member
    May 15, 2007 at 04:13 AM

    Formula is local to the query.

    Ccal key fig is global to the entire info provider.

    Other than , to me both are the same and serve the same purpose.

    Ravi Thothadri

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 15, 2007 at 03:25 AM

    hi,

    formula: is a local calculation that is created under a query structure and can be used in query that it is created.

    CKF: it is a global calculation that can be used across queries on the same infoprovider .

    you can create many formulas under a structure and save the structure globally, so that you can reuse this structure in other queries.

    hope this helps.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Formula : It can be used only in the query which we have defined .

      CKF : It is a global formula.we can use this CKF in any query defined on the same infoprovider.

  • avatar image
    Former Member
    May 15, 2007 at 03:51 AM

    Hi Krishna,

    the fallowing are differences between Calculate key figure and formula.

    Calculated key figure:

    Use

    In the Query Designer, you use formulas to recalculate the key figures in an InfoProvider so that you can reuse them. Calculated key figures consist of formula definitions containing basic key figures, restricted key figures or precalculated key figures.

    Procedure

    Defining a New Calculated Key Figure

    ...

    1. In the InfoProvider screen area, select the Key Figures entry and from the context menu (secondary mouse button click), choose New Calculated Key Figure.

    If a calculated key figure has already been defined for this InfoProvider, you can select the Calculated Key Figures entry and, from the context menu, choose New Calculated Key Figure.

    The system adds the New Calculated Key Figure entry. The properties for the calculated key figure are displayed in the Properties screen area.

    2. Select the New Calculated Key Figure entry and, from the context menu (secondary mouse button), choose Edit.

    The Calculated Key Figure dialog box appears.

    You can also call the Change Calculated Key Figure dialog box from the Properties screen area by choosing the Edit pushbutton.

    Formula:

    Use

    You can recalculate the key figures in a structure using a formula. You can include basic key figures, restricted key figures, and calculated key figures in the formula definition.

    Procedure

    Defining a Formula

    ...

    1. If the query does not yet have a key figure structure, create a New Structure in the Rows or Columns of the Query Designer by highlighting the row or column directory using the secondary mouse button and selecting New Structure from the context menu.

    2. If the structure does not yet contain any key figures, use drag and drop to transfer a (basic) key figure of the InfoProvider into the directory of the new structure.

    3. Select the structure directory, and choose New Formula. The New Formula entry is inserted and the properties for the formula are displayed in the Properties screen area.

    4. Select the New Formula entry and, from the context menu (secondary mouse button), choose Edit. The Change Formula dialog box appears.

    You can also call the Change Formula dialog box from the Properties screen area by choosing the Edit pushbutton.

    regards,

    shailaja

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 17, 2008 at 10:04 AM

    Hari,

    I will tell u shortcut CKF and Formula.

    Formula is a Local to effect to particulat query only it can't effected all queries but Calculated KeyFigure(CKF) is a global to effected all the queries under the Cube are Multiprovider.

    I think is is helpful to u hari

    Regards,

    Lakshmi

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 17, 2008 at 10:18 AM
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 13, 2015 at 05:26 PM

    Hi Krishna,
    As you see above the difference between formula and calculated key figures rightly pointed out by Gurus, I would just like to add here from the application perspective.

    Say on top of a multi provider there are multiple queries and these queries uses the a single calculation across then always create a Calculated key figure which you can use across any query, In other words always create these calculated key figures at the very generic level, for example not restriction with time characteristics, customer exits and so on. I believe it will help you big way when you are in big project and want to avoid re-work.

    On contrary, if you are very sure about any formula which is very specific to the query I would suggest you to create the formula at local section. But be clear while you create formula you cannot use the global calculated/restricted key figures until you brought them in the local pane of the query.

    Also from the transport perspective, you need to be careful that while you transport the query first time to the next system you have to collect the calculated key figures specifically where as you do not have to do that for formula. It will automatically get collected along with he query. Any subsequent change in calculated key figure also require collection of the same. But here the good point is, say for example, you have a query and in that there is a change required in the logic of calculation, and earlier this was achieved by calculated key figure, then after you change the calculated key figure you do not have transport the whole query but transporting only the calculated key figure will do. This is way your transport becomes less heavy as well.

    Hope it adds. Assigning points would be great to any pointer.

    Regards
    Sourav

    Add comment
    10|10000 characters needed characters exceeded