How to use a calculated measure in a compound cube ?

Question

Question

Blaise ZARKA · Jun 14, 2016

Hi,

Using cube CubeA and cube CubeB that contains calculated measure TotalClients.
I would like to use TotalClient calculated measure from a compound cube CubeC (CubeA,CubeB).

How would you do that?

Discussion (5)0

Log in or sign up to continue

Evgeny Shvarov · Jun 15, 2016

I think the problem is that you use calculated measure for the measure with the same name - f.e. count.

To solve this introduce the measure for Count with another name, f.e. CubeACount and use calculated measure to use this measure in the expression.

Hope it helps.

0 0

score 0 · Answer 1 · 2016-06-14T12:06:37-04:00

It's not very clear. You want to use CubeB.TotalClients in CubeC compound cube?

What this measure should show in CubeC?

score 0 · Answer 2 · 2016-06-14T12:45:00-04:00

Yes, I'd like to use CubeB.TotalClients in CubeC compound cube.

TotalClients in CubeC should use only the members in CubeB and thus should return the same number as in CubeB.

score 0 · Answer 3 · 2016-06-14T12:52:31-04:00

I believe it should just work. Place CubeB.TotalClients in pivot based on CubeC and you'll get the CubeB.TotalClients for the facts in CubeB only.

The idea of compound cubes is that you get pivot table with different measures from different fact tables sliced by same shared dimension.

score 0 · Answer 4 · 2016-06-14T13:04:26-04:00

I can see the measures but not the calculated measures coming from CubeB in CubeC in the pivot table.

I'm currently trying to have a shared dimension between CubeA and CubeB and to use this dimension only in the calculated measure in CubeB. To see if it works.

Thanks Evgeny!