Search found 3 matches

by whitelillie
Wed May 08, 2019 2:52 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI - Add new element in alphabetical order under consolidation
Replies: 17
Views: 1132

Re: TI - Add new element in alphabetical order under consolidation

That said, I would not necessarily recommend using people's names as principal element names. If someone changes their name (as some newly married women have an annoying (from a system point of view) habit of doing), you'll need to export all of the data relating to that element and create a new on...
by whitelillie
Wed May 08, 2019 12:32 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI - Add new element in alphabetical order under consolidation
Replies: 17
Views: 1132

Re: TI - Add new element in alphabetical order under consolidation

Create a TI with a dimension parameter and copy the following code in the prolog. It will solve all your problems ! ################################################### # # This TI sort order for the dimension entered as parameter. # All dimension elements are sorted in ascending by level, # and any...
by whitelillie
Tue May 07, 2019 8:06 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI - Add new element in alphabetical order under consolidation
Replies: 17
Views: 1132

TI - Add new element in alphabetical order under consolidation

I'm a pretty new user of TM1 (using version 10.2.4) I have a dimension that is list of employee names with a single consolidation called "All Employee Names". The dimension looks some this like this: All Employee Names adam-jones brett-smith david-collins Each time a new employee name is added to th...