Search
Search

# Problem with result of CKF on a multiprovider

hello, I have another question about infocubes and like everytime that I don´t know how to make something, I come here to see if someone could give a hand.

I got a multicube based on this two 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

MULTICUBE (using constant selection for C3)

C1 C2 C3 KF1 KF2 CKF(KF1*KF2)

-

-

1 1 1 50 150 7500

1 1 2 75 150 11250

1 2 1 100 100 10000

2 1 1 25 35 875

2 2 1 30 85 2550

2 2 2 50 85 4250

And I calculate the result of CKF as sum, so it is: 36,425

The problem is that I change the drill down of characteristics in the query the result of CKF is different.

for example:

C1 kF1 KF2 CKF(KF1*KF2)

-

-

1 225 250 56250

2 105 120 12600

So the sum of CKF would be 68,850 instead of 36,425 that is the value that I would like to get, independently of characteristcs that I'd have in the drill down.

I thought that this could be made using calculate before aggregarion but if I select this option the result is 0.

Is there any way to perform this ?

Sebastián.-