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.
PAX – User Defined Consolidations
-
RonLat
- Posts: 19
- Joined: Tue May 02, 2017 7:49 am
- OLAP Product: TM1, Planning Analytics
- Version: 2.0
- Excel Version: 365
PAX – User Defined Consolidations
- Attachments
-
- TM1_Perspectives_Subset.jpg (16.25 KiB) Viewed 3337 times
-
lotsaram
- MVP
- Posts: 3703
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: PAX – User Defined Consolidations
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).
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.