TM1 Forum

In TM1-Perspectives there is a possibility of using the user defined consolidations. This is a subset that contains other subsets as elements and can be used as an argument in a DBRW formula. This does not work in Planning Analytics for Excel (PAX) anymore. Is there a practical solution to this problem in PAX?

Example: The Subset LT_Series consist of the Subset L_Series and T_Series.

This feature is coming in PAW and to be assumed PAfE also. The implementation is a little different (i.e. no longer subset in subset but MDX aggregate) but the functionality is the same (but actually better as the aggregates can also be used on filter and views containing such user defined calculations can be shared and made public which wasn't the case with UDCs).