Manual Sort Order TI Process

Post Reply
mnasra
Posts: 118
Joined: Tue Aug 10, 2010 5:40 pm
OLAP Product: Planning Analytics
Version: 2.0
Excel Version: EXCEL 2013

Manual Sort Order TI Process

Post by mnasra » Tue Jun 01, 2021 2:34 pm

Hi Experts,

I need to keep the SORT Order of the Chart of Accounts dimension as Manual.
But I want all level 0 items to be 'automatically' sorted under level 1 (their immediate rollup)
Has anyone written a TI process for that?
is there a different solution?

thank you
PS: I tried to search in the forum, could not find anything.
Thanks
Micheline

tomok
MVP
Posts: 2808
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: Manual Sort Order TI Process

Post by tomok » Tue Jun 01, 2021 5:45 pm

mnasra wrote:
Tue Jun 01, 2021 2:34 pm
is there a different solution?
Yes. Maintain the dimension through an XDI spreadsheet. This will let you fine tune the order any way you want. AFAIK there is no other way to achieve what you are asking.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/

mnasra
Posts: 118
Joined: Tue Aug 10, 2010 5:40 pm
OLAP Product: Planning Analytics
Version: 2.0
Excel Version: EXCEL 2013

Re: Manual Sort Order TI Process

Post by mnasra » Wed Jun 02, 2021 1:02 pm

Thank you Tomok,
I was afraid that would be the answer when I saw how many people read my post and did not answer!
Thanks
Micheline

declanr
MVP
Posts: 1712
Joined: Mon Dec 05, 2011 11:51 am
OLAP Product: Cognos TM1
Version: PA2.0 and most of the old ones
Excel Version: All of em
Location: Manchester, United Kingdom
Contact:

Re: Manual Sort Order TI Process

Post by declanr » Wed Jun 02, 2021 5:24 pm

You can have both element and component sort as “byinput”.

You then have to use something like a shadow dimension to do all of your manual sorting in and then have a TI process do complete rebuilds on your main dimension with the shadow dimension as a source, the code then very carefully inserts new elements and components in your desired order.
Declan Rodger

Post Reply