Search code examples
ssisssascube

SSAS cube updating problem

I have created a SSAS project and it works perfectly fine my cubes, data-sources and such first time I deploy the cube, but if I change the data in my database and I click Cube>Process in BIDS it will not reflect the new changes even though when I retrieve the table data in SQL server Management Studio the table shows my data is changed.

I have also tried updating the cube in SSIS package using the Analysis Services Processing Task. However, the changes in my underlying data is not shown. It stays the same. Can anybody give me the few possible scenarios that can cause this problem. Much appreciated

Thanks in Advance

Solution

  • First step is to verify that the datasource ON THE SERVER (not locally on your dev machine) is set to the correct database.