SSAS cube updating problem

Question

Hello There

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

Answer 1

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

Answer 2

Are you processing the whole project or just the cube? I noticed that I have to process the top level item in the solution explorer. Processing just the cube was not enough.

Do you get any error messages?

Try processing the dimensions first and then process the cube.

I am not an expert myself, but I understood that there is a difference between updating ("process") and "deploy".

So when you create or add dimensions you will first have to deploy the cube to the analysis server and then process it.

Later when there is new data in your datasource, you can just process the cube (it's already deployed) to update the data.