ElementParent Function return blank

Post Reply
Ashleigh W
Posts: 88
Joined: Mon Oct 24, 2016 1:21 pm
OLAP Product: TM1
Version: TM1 Perspectives 10
Excel Version: Excel 2016

ElementParent Function return blank

Post by Ashleigh W »

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.
User avatar
Steve Rowe
Site Admin
Posts: 2417
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

Re: ElementParent Function return blank

Post by Steve Rowe »

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

Code: Select all

ElementParent('SEVERNAME:Model', 'Automobile', 'Wagon 4WD', 1)
Technical Director
www.infocat.co.uk
Ashleigh W
Posts: 88
Joined: Mon Oct 24, 2016 1:21 pm
OLAP Product: TM1
Version: TM1 Perspectives 10
Excel Version: Excel 2016

Re: ElementParent Function return blank

Post by Ashleigh W »

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

In Excel Sheet it is not recognized.
Wim Gielis
MVP
Posts: 3120
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: ElementParent Function return blank

Post by Wim Gielis »

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

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Ashleigh W
Posts: 88
Joined: Mon Oct 24, 2016 1:21 pm
OLAP Product: TM1
Version: TM1 Perspectives 10
Excel Version: Excel 2016

Re: ElementParent Function return blank

Post by Ashleigh W »

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

Thank you!
Post Reply