How to refresh ssas cube database/table for report

Question

The problem: My SSRS report based on my Cube is not getting the latest data from the table associated with the Cube. How do I either a) tell the report to use the latest table data, or b) delete any report cache file that might be preventing a table data refresh?

Using SQLserver, SSRS, SSAS v2008 R2. I've updated a table structure and its data using queries inside the sql management studio. In the cube using this database/table I've processed and deployed (the cube + .dsv), all looks good. From the report I've tried refreshing the datasource fields, which works, but the data itself is NOT refreshed, and I can't find any options to do just that.

Answer 1

You need to process the cube to get refreshed data into the cube (and your report). Here's screencast on how to do this.

Also you may want to review the MSDN documentation, paying particular attention to the different types of OLAP cube processing that are available, i.e. full, incremental, etc... as you'll probably only want to add new records, rather than erase and full re-populate the cube data on each process.