TM1 Forum

Posted: **Thu Oct 29, 2020 4:15 pm**

Hello experts, I have been trying to get parent of element from specified hierarchy but it wont work for me

I tried in below format with multiple sample of index 1,2,3 etc. but it won't return any value. In Model Dimension I have 4 top / parent node / hierarchy.

ElementParent('Model', 'Automobile', 'Wagon 4WD', 1)

please advise.

Posted: **Thu Oct 29, 2020 4:49 pm**

You need to include the server/DB name in the dimension ref

Code: Select all

ElementParent('SEVERNAME:Model', 'Automobile', 'Wagon 4WD', 1)

Posted: **Thu Oct 29, 2020 4:52 pm**

I am trying this in TI and Rule as well it does not work in both.

In Excel Sheet it is not recognized.

Posted: **Thu Oct 29, 2020 6:09 pm**

You are using a PA version that supports this relatively new function ?

Posted: **Fri Oct 30, 2020 10:45 am**

that must be the reason. I use PA.
Within the documentation IBM didn't mentioned it or I must have missed it

Thank you!

TM1 Forum

ElementParent Function return blank

ElementParent Function return blank

Re: ElementParent Function return blank

Re: ElementParent Function return blank

Re: ElementParent Function return blank

Re: ElementParent Function return blank