Search code examples
sql-server-2008-r2ssasbusiness-intelligence

How to propagate changes to analysis services after updating the database

I changed dimension table (what i did? i changed the length of a column in SQL Server 2008R2). When i try to deploy my cube in analysis services, it doesn't work !!

i checked the column length in analysis services it stil keep the old length value, then i would like to propagate this change between sql server and analysis services without having impact to other dimension tables or fact tables?

The column length in SQL Server is : 300 but still the old one 150 in SSAS

thanks in advance.

Solution

  • Open the DataSource View right click on "refresh". This will update the columns in SSAS.