Cubes

Divya Kohli

Let's suppose I have a cube with dimensions month, scenario, version, competency and another cube with dimensions month, scenario, version, los, location. The end cube in which I am storing the value also has location at it's dimension.

LOS and competency entities are in relation LOS being the parent and competency being the child. Now I am multiplying both the cubes, but it's giving me the wrong numbers because of location dimension.
What should be the other approach I can do instead of adding location as a dimension in first cube.

Helmut Heimann

Hi @Divya Kohli ,

you could do the multiplication in a loop on "location", each location's values are copied one after the other into the target.
Our How-To section has a document on loops:

https://community.board.com/discussion/18090/how-to-loop-procedures

Best,
Helmut