Hi TM1 Community,
Am I the only one who miss DTYPE function for hierarchies? I found no article or APAR or anything about it.
I tried to use it in a process, but it didn't work no matter, if I tried with DTYPE(Dim:Hier, Element) or DTYPE(Dim,Hier:Element). (Syntax error).
The only weapon I left, that I check the ElementIndex in Leaves hierarchy, and if 0, than the element must be C.
But I don't know, how could I check for an attribute if it is an Alias or not, for an attribte exists only in a specific (but not the main) hierarchy.
Do I miss something? Does anyone have a better idea?
Thank you for your insight or suggestions in advance.
(PS: TM1 Build Number: 11.8.00200.24)
DTYPE for hierarchies?
-
- MVP
- Posts: 3233
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.1.5
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: DTYPE for hierarchies?
Best regards,
Wim Gielis
IBM Champion 2024-2025
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-2025
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: 5
- Joined: Thu Feb 22, 2018 4:19 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2016
Re: DTYPE for hierarchies?
Hi Wim!
Thank you for your answer. It made me feel soooo dumb.
I have no idea why I missed this. Maybe I should work less and sleep more
Thanks again!
Thank you for your answer. It made me feel soooo dumb.
I have no idea why I missed this. Maybe I should work less and sleep more

Thanks again!
-
- MVP
- Posts: 3703
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: DTYPE for hierarchies?
this will also work
DType( 'dim:hier', sElement)
or in terms of varialbled you might have
DType( sDim |':'| sHier, sElement )
Note the single quotes around the dimension name : hierarchy name. ALL the new hierarchy functions are nothing more than routing shortcuts to the existing functions passing the dimension and hieraarchy joined by a colon.
DType( 'dim:hier', sElement)
or in terms of varialbled you might have
DType( sDim |':'| sHier, sElement )
Note the single quotes around the dimension name : hierarchy name. ALL the new hierarchy functions are nothing more than routing shortcuts to the existing functions passing the dimension and hieraarchy joined by a colon.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.