refresh data

Question

Hi,

I am new to ssas and i have a question about refreshing data from the source

how new data from the source (populated through ETL everyday) is refreshed in SSAS. Please someone clarify me.

Thanks
Sengwa

Answer 1

Hello Sengwa,

if you what the data in you SSAS cube to be "refresh", you have to process the cube again; then the datas are read from dataware house, aggregation are build again and so on.
You can process the different objects of a SSAS database on its own, but you have to take care about dependecies, e.g. you have to process dimensions (if there are data updates) before you process a measure group. 
If you have enterprise edition of SSAS and you use partioning, you could process each partionion on its own.

---

Olaf Helper ----------- * cogito ergo sum * errare humanum est * quote erat demonstrandum * Wenn ich denke, ist das ein Fehler und das beweise ich täglich http://olafhelper.over-blog.de

Answer 2

Thanks a lot for your reply Olaf. Your reply give a brief overview of processing SSAS cube.
Really Appreciate it

Best regards,
Sengwa