The ‘DataSourceView’ with ‘ID’ = ‘Adventure Works DW2008’ doesn’t exist in the collection.

One of my goals for this year has been to learn more about SQL Server Analysis Services. So I’ve bought myself a (very fat) book on the subject and have started to work my way through it. A few days ago I built the first example cube in Chapter two. Coming back to it this evening, I opened the project in BIDS, and was presented with the following error in the cube designer.

ssas designer data source view collection error

I recalled renaming the DataSource View, and have experienced similar issues with renaming objects in SSIS, so I decided to check out the properties of the DataSourceView.

Mmmm, the ObjectId here has a ‘1’ on the end which implies to me it has been copied and pasted from an original. This info appears to be read only here so I decided to dive into the cubes xml. The xml of a cube can be viewed by right-clicking on it in Solution Explorer and choosing “View Code”.

$ssas\_cube\_xml$

I found one reference to Adventure Works DW2008 in this XML between <DataSourceViewId> tags. I changed this to the Id of Adventure Works DW2008 1 as below.

$ssas\_cube\_xml2$

I then saved the project and went back to the cube designer.

Excellent. I have repaired my broken cube! Now on with Chapter three!