Planning Analytics

 View Only

 Question for June 2025 AMA

John O'Leary's profile image
John O'Leary posted Mon June 16, 2025 08:21 PM

My question relates to PAfE. 

To date there are a number of hierarchy aware worksheet functions available in PAfE, eg: TM1VAL, TM1SET, DEFINECALC and a few others.

Legacy TM1 functions exist to retrieve certain structural information.

DFRST
DIMIX
DIMNM
DIMSIZ
DNEXT
DNLEV
DTYPE
ELCOMP
ELCOMPN
ELISCOMP
ELISPAR
ELLEV
ELPAR
ELPARN
ELWEIGHT

These functions are invaluable when building UI's and reports

A large number of Hierarchy aware TI functions were released in Server 11 to manipulate / interrogate structural information but to date there has been no equivalent PAfE worksheet functions / capability.

What is the plan to provide hierarchy aware worksheet functions with similar capabilities to those above / similar to the the TI hierarchy aware functions?