Issue with Key figures on a Multicube
Hello People! Hope you're doing well...
I got a problem that needs to be resolved and I know this is the best place to look for the answer.
I have 2 cubes:
CUBE1
C1 C2 C3 KF1
-
1 1 1 50
1 1 2 75
1 2 1 100
2 1 1 25
2 2 1 30
2 2 2 50
CUBE2
C1 C2 KF2
-
1 1 150
1 2 100
2 1 35
2 2 85
Then I have a Multicube using these 2 infocubes.
In a query if I try to see the info what I see is:
C1 C2 C3 KF1 KF2
-
1 1 1 50
1 1 2 75
1 1 # 150
1 2 1 100
1 2 # 100
2 1 1 25
2 1 # 35
2 2 1 30
2 2 2 50
2 2 # 85
BUT (and here comes the big question...) what I need is to see the query like this, sol I can have a third CKF that should be KF1/KF2:
C1 C2 C3 KF1 KF2 CKF(KF1/KF2)
-
1 1 1 50 150 0.333
1 1 2 75 150 0.5
1 2 1 100 100 1
2 1 1 25 35 0.714
2 2 1 30 85 0.353
2 2 2 50 85 0.588
Any Clue? I Would really appreciate (and award) any helpfull answer...
Thanks in advance...
Sebastian.-
Former Member replied
Sebastian,
here is a solution for your problem.
In the query designer, for KF2, put a "constant selection" on C3. This is how you can do it.
right click on the KF2 in the query and "edit". In there pull C3 to the right side, right click on it and click on "constant selection"...
It should work. Let me know
Good Luck
Gova