DTYPE for hierarchies?

Post Reply
kunbela
Posts: 5
Joined: Thu Feb 22, 2018 4:19 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2016

DTYPE for hierarchies?

Post by kunbela »

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)
Wim Gielis
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?

Post by Wim Gielis »

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
kunbela
Posts: 5
Joined: Thu Feb 22, 2018 4:19 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2016

Re: DTYPE for hierarchies?

Post by kunbela »

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 :D

Thanks again!
lotsaram
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?

Post by lotsaram »

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.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
Post Reply