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