Hello Everyone!
I would like to allow the weighting of the companies into the group to be dynamic and change over time. Therefore hardcoding it into the weighting of the dimension is not a great solution, if I would change it that would affect everything retroactively.
I guess one possibility would be to store the weighting ratios in a cube in relation with the time dimensions, and simulate the consolidation of the dimension with rules using that cube.
I was just wondering whether anyone came to a better solution than that.
Thanks a lot!!
Zsolt