Issue with Key figures on a Multicube

[Former Member]

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 · Accepted solution]

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

[Former Member · Accepted solution]

Yes Gova!

You were right, thanks a lot.

Your points are awarded.

By the way, what's the porpouse of this 'constant selection' option? how does it work?

Thanks. Best wishes.

Sebastian.-

[Former Member · Accepted solution]

Your situation is the best scenario for an example of Constant Seelction.

When you do that, the C3 value for the KF2 is ignored (which will be #) and the union takes place based on C1 and C2.

So, whenever you have multiprovider built like this, you need to use constant selection when defining keyfigures on those characteristics which are missing in the iNfocube (in which KF exists).