Tips for bunch change member names
Summary:
Content (please ensure you mask any confidential information):
Hi,
Want to see if anyone has better idea or tips for bunch changing member names. For example, initially we have 500 members in Dim1 and 1000 members in Dim2, all loaded with data. Now we need change the member names for 200 members in Dim1 and 300 members in Dim2, and need to keep the data. What would be the better, effort-saving, and safe way to achieve this. Note that there is only one environment available, thus we have less choice for trying out.
#1. Manually change the member name in editor, tedious enough.
#2. Export dimension metadata, make all the changes and import back with "clear members", but this would clear the data on refresh, and need to take backup of level0 data and make all name changes as well in the data file , the restore data after metadata changes. Also tedious.