you cannot rename a member, the member name is what it is.
You can change its alias.
You can delete the member and add a new member of a different name.
But you cannot rename the member name.
Btw - if you delete you lose any data stored against the member.
To change aliases, export the dimension, look at the file.
Build up a file in the same format with the same headings and delimiters for the columns you need to change.
Refresh the DBs.
You can use your spreadsheet tool of choice to parse the columns, change what you need to, cf my original comment on not being able to change member names, save as comma delimited (watch out for commas in the content!) and reimport.
Thanks for the input Robert. Here's what I plan to do:
1) Add members with new names as the siblings of the old ones.
2) Move all the children from old members to the new.
3) Delete old members
1 person found this helpful
You would want to go and check rules,reports and data forms which those old members are references in also.
I would also back up your application / DBs before you start, just in case you do lose any data...
And reconcile before and after.
Thanks for your input guys.