Welcome to MSSQL Forum!
MSSQL Forum - Discussions about Microsoft SQL Server

You are currently viewing our community forums as a guest user. Sign up or
Having an account grants you additional privileges, such as creating and participating in discussions.

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

Discussion in 'Business Intelligence' started by Peter Schmitz, Jun 12, 2017.

  1. Peter Schmitz

    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:

    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.

Share This Page