Expanding the elements of a members set in Custom Report of TM1

Post Reply
khari14
Posts: 1
Joined: Thu Sep 02, 2021 5:14 pm
OLAP Product: Planning Analytics
Version: 10.2.2
Excel Version: PAx

Expanding the elements of a members set in Custom Report of TM1

Post by khari14 » Thu Sep 02, 2021 7:25 pm

Hello All

I have a custom report with 3 dimensions in 3 columns with highest level of hierarchy. I want to expand all the descendants and children of each of the column to different set of columns retaining the hierarchy basically I need to flatten the hierarchy and do denormalization. Can you give me the TM1 excel functions which can help me do this functionality for my custom report in TM1?

Regards
Hari

Post Reply