Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question