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.
