Search code examples
ssisssas

SSAS Data Source View Does Not Show newly added column

I am newbie on SSAS. I added a new column to a destination table in SQL Server. I also mapped the new column in an ssis package, but data source view in Cube does not show the column. I've already checked the connection and host. All are correct but when I refresh the dsv the column does not appear. If I add the column on dsv , I'll add the column as measure. By the way the project has already deployed.

Thanks for suggestions.

Solution

  • Edit the DSV and explicitly add the column.