Search found 3 matches
- 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: 12269
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...
- 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: 12269
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...
- 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: 12269
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 a...