Changing object ID in SSAS BIDS
June 24, 2014 1 Comment
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.
About Dan Wakefield
Dan's BI Braindump 
Great tip. Only extra I would add is that I had to right click the object (in my case a dimension) from the Solution Explorer so that I could see the View Code option. Thanks.