All dimensions with PA hierarchies

Ideas and tips for enhancing your TM1 application
Post Reply
Wim Gielis
MVP
Posts: 2109
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0.7
Excel Version: Office 365 - latest
Location: Brussels, Belgium
Contact:

All dimensions with PA hierarchies

Post by Wim Gielis » Fri Jul 26, 2019 9:21 am

Hello all,

Since some time now we can use hierarchies in IBM Planning Analytics. Any dimension can become a container of 1 or more so called hierarchies.Here is a dynamic subset on the }Dimensions dimension to identify all dimensions that contain hierarchies:

Code: Select all

Filter( TM1SubsetAll( [}Dimensions] ), Instr( [}Dimensions].CurrentMember.Lead(1).Name, [}Dimensions].CurrentMember.Name + ":" ) = 1 )
A TI process with a simple loop can suffice too but a dynamic subset seems more useful.

Wim
Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 109 TM1 articles and a lot of custom code
Newest blog article: Set up a TM1 service with AutoHotKey

Post Reply