Is TM1 dimension index important?

Post Reply
zyzhang6
Posts: 1
Joined: Wed Nov 08, 2017 8:58 am
OLAP Product: TM1
Version: 10.1.1
Excel Version: Excel 2013

Is TM1 dimension index important?

Post by zyzhang6 »

Hi Everyone,

Please forgive me ask this stupid question. I just shift the system from Oracle HFM to TM1. There is one thing I am quite confuse at TM1 is about the dimension index. In HFM, when I write calculation rule, I always use the parent-child relationship to identify the elements involve in a calculation. For example, run this rule at all base accounts under "Total Assets". I do not need to take care about the exact index number of the element.

May I know whether this is the same case in TM1?

Thanks.

James
ascheevel
Community Contributor
Posts: 286
Joined: Fri Feb 15, 2013 5:49 pm
OLAP Product: TM1
Version: PA 2.0.9.1
Excel Version: 365
Location: Minneapolis, USA

Re: Is TM1 dimension index important?

Post by ascheevel »

You would write the rule in TM1 similar to how you did it in HFM, you don't need to account for the element index. In TM1, you can use ELISANC or ELPAR to determine if element is descendant/child of "TOTAL ASSETS".

I really only use an element's index when looping through elements of a dimension in a TI process or using DIMIX to determine if an element exists in the dim. You could use the element index in a time dimension to return prior/next although my preference would be to use attributes in that case.

Hope this helps and welcome to TM1.

-Andrew
tomok
MVP
Posts: 2831
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: Is TM1 dimension index important?

Post by tomok »

The dimension index number has absolutely nothing to do with the parent child relationship of elements. It is simply the order of the dimension element in a list when the dimension was saved. When you create and save a dimension in TM1 (unless you used an XDI worksheet), the index numbers are automatically assigned either 1) in the order the element was added, or 2) alphabetically. It may or may not be in a parent-child order. Best to just forget about the index number except when using the DIMIX function in a TI process. For a rule, always use ELPAR or ELISANC, or create your own index number and store it in an attribute and reference it with ATTRN.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
Wim Gielis
MVP
Posts: 3105
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: Is TM1 dimension index important?

Post by Wim Gielis »

One area where the the index order is important, is when you expand a consolidation.
Then TM1 will show the immediate children based on the index.
One might want to change the index when this is important.
For example, Total Year has 12 children as the months. Then you don't want to have a random list of elements when you expand Total year in a view.
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
Thurston Howell III
Posts: 36
Joined: Fri Mar 10, 2017 8:26 pm
OLAP Product: TM1
Version: PA 2.0.8
Excel Version: 2016
Location: Dallas, TX

Re: Is TM1 dimension index important?

Post by Thurston Howell III »

It is absolutely important, just not for what you're looking to do.

The benefit of the index numbers is that every element, regardless of how of how often it appears in a dimension, will have one identifying index number, which is very helpful if you're writing TI processes that edit your dimension structure or test for existing elements.
Post Reply