The data source view does not contain a definition for the table or view ‘dbo_Fact_xxxx’. The Source property may not have been set.
Last week i was working on redeploying an existing cube to another server. While doing so i was tiding up the source control at the same time. As it happened few of the tables were missing the dataware house database. Having created the tables and views i refreshed the DSV and deployed the same to server. I was hoping this to be simple enough task and be done by afternoon. This seemingly simple task took me upto evening to finish.
During the build there were no error’s however when i tried to deploy it gave me the error:The data source view does not contain a definition for the table or view ‘dbo_Fact_xxxx’. The Source property may not have been set.
I can see clearly the said table was in datasourceview and database. Having spoken to my colleagues we could not figure out the reason why the error occurred. After googling i could not find solution to my issue. Most of them were talking about the Proactive Caching or recreating the measure. Both of which were not applicable to my issue. Especially i could not risk recreating the measure from scratch.
Solution
And then finally after staring at the error for 10 minutes i thought to myself the only difference between the names is the casing of the words. Previously , this table was named in camel casing. After recreating this table is in all upper case. Switching the datasourceview to code view which opens up the XML. While editing the XML the table name is matched to the casing in the database.
Rebuilding and deploying the cube now caused the error to disappear.It was bit queer in the sense that SQL Server was not set to be case sensitive. However, the cube was behaving as if it was.
Happy Analysing!!