Skip navigation.
spilling the beans

renaming elements

| |

renaming elements without activating aliases? Yes we can!
The dimension editor and dimension worksheets cannot rename elements directly, so let me introduce you to SwapAliasWithPrincipalName.

before swap:
before swap

.create a new alias "new" in the Dimension, by default the new elements are identical
.change all required elements to their new names in that alias. Below we pad a zero in front of all elements
new alias

.create a new TI with the following line in the Prolog:


The third parameter needs to be zero to execute the swap. If it has any other purpose, please edit/leave a comment.

after swap:
after swap

Old is the new alias:
old is the new

/!\Make sure the associated dimension worksheet is updated if there is any!!!

This was tested successfully under v. 9.0.3 and v. 9.4.
This TI function is listed in the documentation, however there is no description of its function and syntax.

Click on the RTFM FAIL tag to find out some other poorly documented or simply undocumented TM1 functions.

Average rating
(1 vote)