Hi All,
I have a requirement rename dimension element-I am not sure we have element rename option is available. Do I need to delete the existing dim element and then add back?
But - I have data available-present and previous. In this case do i need to export the existing element data and then load back to NEW dim element?
Please suggest best practice.
Thanks
Ravi
Element rename
-
BariAbdul
- Regular Participant
- Posts: 424
- Joined: Sat Mar 10, 2012 1:03 pm
- OLAP Product: IBM TM1, Planning Analytics, P
- Version: PAW 2.0.8
- Excel Version: 2019
Re: Element rename
Please have look :
http://www.tm1forum.com/viewtopic.php?t=3832
http://www.tm1forum.com/viewtopic.php?t=569 Thanks
http://www.tm1forum.com/viewtopic.php?t=3832
http://www.tm1forum.com/viewtopic.php?t=569 Thanks
"You Never Fail Until You Stop Trying......"
-
declanr
- MVP
- Posts: 1828
- 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: Element rename
Those links are a bit old so could be quite misleading.
Generally nowadays people just use the SwapAliasWithPrincipalName function.
You create a new alias, populate with your replacement name/s and then the function via TI overwrites the principal names with the alias. You can then delete the alias or keep it as it will now contain the old names.
Generally nowadays people just use the SwapAliasWithPrincipalName function.
You create a new alias, populate with your replacement name/s and then the function via TI overwrites the principal names with the alias. You can then delete the alias or keep it as it will now contain the old names.
Declan Rodger