Picklist using Alias

Post Reply
M1_A1
Posts: 5
Joined: Mon Nov 16, 2009 8:14 pm
OLAP Product: TM1
Version: 10.1.1
Excel Version: 2010
Location: Chicago

Picklist using Alias

Post by M1_A1 »

I am using a subset (set to an alias) in a picklist for users to use in input cubes.
If the alias description is changed the user will see the updated picklist in the drop down list but any previously selected items using the old alias do not change.

I am interested in what strategy others have used in this situation. I am considering adding another alias to the dimension "old_Alias" for older changes. It would allow the rules to still work but it would still use the old description. Otherwise I could create a TI to search all potential input cells and replace with new name.

Using V9.5.2

Thanks
User avatar
Harvey
Community Contributor
Posts: 236
Joined: Mon Aug 04, 2008 4:43 am
OLAP Product: PA, TM1, CX, Palo
Version: TM1 8.3 onwards
Excel Version: 2003 onwards
Contact:

Re: Picklist using Alias

Post by Harvey »

I would suggest it is bad practice to allow aliases to change. Aliases are intended to be an alternative name for an element, and an element almost always represents something unchanging by its nature. Given this, there is not much reason a description about it should change either.

If you absolutely can't get around allowing alias changes, you could do something like you suggested in your original post, and perhaps set up a chore run overnight to set all old values to new ones. It could get a bit messy, though, and what if it changes twice?

Personally, I would look into creating new elements instead of changing the aliases of old ones, but it totally depends on what your dimension represents.
Take your TM1 experience to the next level - TM1Innovators.net
Post Reply