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.
ElementParent Function return blank
-
- Posts: 88
- Joined: Mon Oct 24, 2016 1:21 pm
- OLAP Product: TM1
- Version: TM1 Perspectives 10
- Excel Version: Excel 2016
- 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
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
www.infocat.co.uk
-
- 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
I am trying this in TI and Rule as well it does not work in both.
In Excel Sheet it is not recognized.
In Excel Sheet it is not recognized.
-
- 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
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
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
-
- 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
that must be the reason. I use PA.
Within the documentation IBM didn't mentioned it or I must have missed it
Thank you!
Within the documentation IBM didn't mentioned it or I must have missed it
Thank you!