Do multiple hierarchies use more memory?

[mweldon]

Hi, quite a basic theoretical question - if I have multiple hierarchies in my dimension, what scale of memory/cube increase will there be? e.g. will 2 hierarchies take up twice the memory of a single hierarchy?

thanks

Marc

[lotsaram]

TM1 does not pre-calculate consolidated values. Any calculated values are done on the fly as a result of user requests.

Additional hierarchies will therefore have an effect that is exactly zero in terms of cube size (as only leaf level data is permanently stored) and very close to zero in terms of total resources as the memory used to store the additional dimension structure is typically very small.

More values might be cached due to the additional hierarchy but this depends on how frequently values are queried and the size of view cache allocated to particular cubes but the size of the cache won't change (old views just get thrown out if the limit is exceeded.)

The overall effect will be pretty low, I would doubt it would be perceptible unless you are talking of a product dimension with hundreds of thousands of members or similar.

[mweldon]

excellent thanks, that was what I expected/hoped so good to confirm it.

Many thanks for your concise response