SSAS - "The data source view does not contain a definition for <column>"

Peter Schmitz

Administrator
Staff member
If you ever renamed a column in a source table or view, you might have ran into the dreaded error:

The data source view does not contain a definition for <column> in the <table> table or view"

It usually means you need to refresh your data source view. However, you will need to ensure that any references to the particular column are also covered. Today, I ran into a situation where a dimension we originally referenced once now was split up into a role-playing dimension.

I.e. We originally referenced the Date dimension to lookup OrderDate. Recently, we added a new date column called PaymentDate., This means a second lookup and of course an extra column, while the original DateID column was renamed. However, in the Dimension Usage tab, the old reference to DateID still existed.

Once that was updated, the error disappeared and processing the cube was succesful.
 
Top