MDX for Ad-Hoc Roll-ups
Posted: Fri Jun 16, 2017 1:02 am
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
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