Incremental Cube Refresh using SSIS

This article shows how to incrementally refresh cube using SSIS.

Step 1 -  First Incrementally load the Fact Tables.(Insert data in the fact tables for today)

Step 2 -  Make a SSIS package for Cube Refresh

1. Add Analysis Services Processing Task in your package
   
   
   
   
2. Right click on the Connection Manager Pane and Select New Analysis Services Connection
   
   
   
   
3. Click Edit Button
   
   
   
   
4. Give the name or IP of the Analysis Services Server and Select the Database
   
   
   
   
5. Test Connection and then click OK.
   
   
   
6. First rename the analysis Services process Task to Process Dimension. Click Edit 
   
   
   
   
7. Go to Processing Settings and then Add all the dimension by clicking add button
   
   
   
   
   
   
   
   
8. Click OK
   
   
   
9. Keep the Process Options to Update
   
   
   
   
10. Click OK
    
    
    
11. Now add as many Analysis Services Procession Task to your SSIS package as many cubes you have.
    
    
    
12. This time add the Cubes or Measures or Partition you want to process 
    
    
    
    
13. Select Process Incremental in the Process Options and then click Configure. A new window will be open then Select Query Radio button and then enter a SQL query.
    
    
    
    And then click ok and again click ok.

You are through.

All Queries are welcome !!