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:
A TI process with a simple loop can suffice too but a dynamic subset seems more useful.
Code: Select all
Filter( TM1SubsetAll( [}Dimensions] ), Instr( [}Dimensions].CurrentMember.Lead(1).Name, [}Dimensions].CurrentMember.Name + ":" ) = 1 )