Analysis Services (SSAS) Processing and Aggregations
I get a lot of questions about this and see quite a few postings about Analysis Services processing in the MSDN forums. So you created an SSAS database solution and have deployed it to a production environment. Now the data has accumulated and you need to take a look at moving to a incremental processing approach because you are either loading the data more regularly or the volume of data and processing does not meet your maintenance window anymore. So what do you do?
The solution is to look at doing a more incremental processing approach instead of just a Process Full on the database. You have a few options in regards to this and I am going to discuss what happens during a dimension update process and also go over an SSIS solution that I put together.