How to change the DataSourceView of an existing dimension

If you have two or more data source views on your analysis service project, there is a definite possibility to create dimensions using wrong data source view. But you may have confused later on, since SSAS doesn't provide you a direct way to re-change the data source view.

I found that error recently, when I deleted some columns from the Time Dimension on the database, but it wasn't reflect on my Time Dimension on the cube. When I right click and click on 'Edit Data Source View' on the Data Source View pane of the dimension editor window, it was redirected me to a different data source view. So it was a good way to identify whether the dimension is being created using appropriate data source view.

But the solution was rather simple. You only have to do open the dimension using code view and change the DataSourceViewID tag to correct data source view. (It is recommended to get the correct data source view ID from another dimension if possible)

Above method can be used to change the data source view from an existing cube as well.

Finally I would like invite you to read my new and more interesting article on How to use Forex Trading as Part Time Earning Method. It would be more beneficial and interesting thing for you.