Hi,
Does anyone know if we can distinguish between the default hierarchy and other hierarchies using TM1 objects? In order to find all the other hierarchies in a model, for every dimension.
The only place I can see where this is possible is in the }dimensions dimension, the other hierarchies seem to use the colon as a separator to identify the hierarchy,
For example, a Country dimension will have Country as the default hierarchy and Country:Leaves as the leaf hierarchy, Country:West as the West countries etc etc.
But, an existing default dimension may already contain a colon, so finding the colon is not really an ideal option, unless you are strict with naming conventions. Ideally all of these other hierarchies would be in a dimension of their own.
So, is there another way to identify all of the other hierarchies in a tm1 model?
Maren
Distinguish between default and other hierarchies
-
- MVP
- Posts: 3223
- 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: Distinguish between default and other hierarchies
Hello,
Is it possible to create a new dimension with a colon ? Not sure and not on my laptop to check.
Is it possible to create a new dimension with a colon ? Not sure and not on my laptop to check.
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
-
- Regular Participant
- Posts: 432
- Joined: Sat Jun 08, 2019 9:55 am
- OLAP Product: Planning Analytics
- Version: Planning Analytics 2.0
- Excel Version: Excel 2016
Re: Distinguish between default and other hierarchies
Hi Wim,
Maren
No, it isn't!Is it possible to create a new dimension with a colon ? Not sure and not on my laptop to check.

Maren
-
- MVP
- Posts: 3223
- 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: Distinguish between default and other hierarchies
It’s Monday for a reason 

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
-
- Regular Participant
- Posts: 432
- Joined: Sat Jun 08, 2019 9:55 am
- OLAP Product: Planning Analytics
- Version: Planning Analytics 2.0
- Excel Version: Excel 2016
Re: Distinguish between default and other hierarchies
I was lulled in by the fact that they are using a colon in these dimension names, so I just assumed that the character was allowed.
That is my excuse, but maybe Monday is a better one!
That is my excuse, but maybe Monday is a better one!