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

Calculated key figure using the result as an operand.

Hello everyone,

I have the following situation.

CUBE1

C1 C2 KF1

-


A XXX 50

A YYY 75

A ZZZ 100

CUBE2

C1 C3 KF2

-


A 1/2007 150

A 2/2007 100

A 3/2007 200

Output of MULTICUBE query (using constant selections for C1 on KF2 i.e KF2 is independent of C1

and C3 on KF1 i.e KF1 is independent of C3)

Free Selection C3 = 01/2007

C1 = A

C1 C2 KF1 KF2 CKF (= KF1/Summation of KF2)

A XXX 50 # (50/225)

A YYY 75 # (75/225)

A ZZZ 100 # (100/225)

Result

  • * 125 225 (1)

My apologies for the formatting...

The challenge is to come up with the above CKF that has KF1 in the numerator and the result of KF2 in the denominator.

Thanks in advance.

Dorothy

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Feb 02, 2007 at 07:48 PM

    oops there is typo here...

    The Free selection is

    C3 = 01/2007 - 03/2007

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 02, 2007 at 09:35 PM

    Thx Bhanu. I tried to locate SUMGT in the 'data functions' category. The entire 'Result' category function are missing. Any ideas ?

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 02, 2007 at 09:45 PM

    I dont follow you. I am trying to create CKF3 using the "New calculated KF" context menu option on the left hand side of the Bex designer. In the subesequent "Edit Calculated Key Figure" screen I am unable to see the SUMGT function under 'data flow' function category.

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Dorothy,

      When you start creating the calc on the left hand side (as you are doing) certain functions are not available. Instead of doing that, right click on the KF structure in your query and choose New Formula. Now you will be able to see the SUMGT function.

      Hope this helps...

  • author's profile photo Former Member
    Former Member
    Posted on Feb 02, 2007 at 09:53 PM

    Thank you. I see it now.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 02, 2007 at 10:01 PM

    Thank you, Bhanu. That worked.

    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.