Join 2 Cubes 1

[mikelblanco]

Hi ALL

I'm running out of brain cells so please help me. I have two cubes with two different measures in each: Cube A has measure salesprice and Cube B has measure cost, both of them have ITEMID dimension. I want to have both measures in same cube AND sorted by ITEMID. I created a virtual cube but there is no way to sort bouth measures by ITEMID dimension. PLEASE HELP

 

[johnherman]

The ITEMID dimension must be a shared dimension and it must be common in the cubes you want to join. That is, each cube must have been built with the shared dimension (build the dimension first).

-------------------------
The reasonable man adapts himself to the world. The unreasonable one persists in trying to adapt the world to himself. Therefore all progress depends on the unreasonable man. - George Bernard Shaw

 

[mikelblanco]

Hey John, great help man,now I can sleep. Cheers bro