Skip to Content
avatar image
Former Member

Can I get a new CKF from the calculated results of the other two KFs?

Hi gurus,

I uses some boolean operators to calculate two key figures, say KF1 and KF2. What I want to do next is to calculate KF3 = sum(KF1)/sum(KF2) . The trouble is: sumct function will get a different result from the real summation of KF1 or KF2. I can only get it by means of the calculated result. However this kind of result is just for display, isn't it?

Then, I can't find anyway to calculate KF3!

Help!

Regards

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Sep 03, 2008 at 06:10 AM

    Hello,

    your question is not very clear.Bt yes u can definitly create a calculated key figure using other two calculated key fig.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 03, 2008 at 06:21 AM

    There should not be any problem. Go ahead and create the KF3 based on KF1 and KF2.

    Thanks...

    Shambhu

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 03, 2008 at 07:44 AM

    Hi,

    Also please check the your computer Regional settings for excel this may round the value. This you can check after checking the deceimal settings in Query designer for that CKF.

    Regards,

    Vishwa.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      One solution i can think of is,

      Create one charecterstic in the cube, PASSED which shud be filled in using update rules. If rev>100 then fill PASSED = 'Y' else give PASSED='N'.

      In the query , you can filter the charecterstic PASSED='Y'.

      This will remove the row with rev 100 in your example and it will not be considered in teh calculations..

      But, i dont think this is a good solution.After all, for a reporting requirement we are adding new chare to cube. If this is ok for you, then you can follow this.