All dimensions with PA hierarchies
Posted: 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:
A TI process with a simple loop can suffice too but a dynamic subset seems more useful.
Wim
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 )Wim