Changing object ID in SSAS BIDS

Developing an analysis services database in BIDS – You have created a dimension for example based on a table in your dsv called frog

You now want to rename this (for reasons that are entirely your own!) – Changing the name is easy via the properties but changing the ID is a bit trickier.

The trick is to right click the object (in this case the frog dimension) in BIDS and select ‘view code’ – You can then edit the ID here in the first couple of lines.