Calculated key figure using the result as an operand.

[Former Member]

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

[Former Member · Accepted solution]

oops there is typo here...

The Free selection is

C3 = 01/2007 - 03/2007

[former_member188975 · Accepted solution]

Hi Dorothy,

You can try using a formula (CKF3) created doing a SUMGT function on CKF2. This will bring you a whole column populated with the CKF2 value (225) in your example, then you can do CKF1/CKF3.

Hope this helps...

[Former Member]

Thank you, Bhanu. That worked.

[Former Member]

Thank you. I see it now.

[Former Member]

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.

[former_member188975]

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...

[Former Member]

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

[former_member188975]

Are you creating the formula in the left hand side? You will find this function only if you are doing the formula local in the query.

Hope this helps...