Page 1 of 1

MDX for Ad-Hoc Roll-ups

Posted: Fri Jun 16, 2017 1:02 am
by 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

Re: MDX for Ad-Hoc Roll-ups

Posted: Fri Jun 16, 2017 8:28 am
by Wim Gielis
Hello,

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

Thanks