MDX for Ad-Hoc Roll-ups

[grvbahal]

Hi All,

TM1 has the ad-hoc roll-up functionality, which is supper useful to sum elements that do not have a pre-defined consolidation. Is there a way to do something similar though MDX where for one of the dimensions I pass a subset and get the sum of all elements in that subset.

Thanks

[Wim Gielis]

Hello,

Can you first go through the material on this page?
http://www.wimgielis.com/tm1_subsetsthataddup_EN.htm

Thanks