Dynamic weighting of dimension structure

zsolt-pinter

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

martin-reischl

Hi Zsolt,

Consolidation uses a parameter cube for the weights, and an App Engine process to calculate the sum-up balance using the shares. Admittedly, this is not just about percentages. But honestly, I do think that you will need something like this to have a robust and scalable solution that performs well. You can still start with rules of course but I expect that you will end up with a process doing the real work.

Best Regards

Martin