I've got a workbook in which I've changed the name of the members of a dimension (say, Customer Names). There are tens of thousands of customers there and I don't remember how many or which of them I've changed. Now I like to change them back to the original names (as appear in the DB). Is there a 'reset button' for changing the aliases back to their original?
(I'm aware that you can create a new connection and replace that in the original data-source which I have tried. However then, I've got to re-create sets, filters and some of the calculated fields. The workbook is fairly complex; re-creating means testing again. So that's my 2nd last option.)