Incremental Cube Refresh 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

    1.gif

  2. Right click on the Connection Manager Pane and Select New Analysis Services Connection

    2.gif

  3. Click Edit Button

    3.gif

  4. Give the name or IP of the Analysis Services Server and Select the Database

    4.gif

  5. Test Connection and then click OK.


  6. First rename the analysis Services process Task to Process Dimension. Click Edit 

    5.gif

  7. Go to Processing Settings and then Add all the dimension by clicking add button

    6.gif

    7.gif

    8.gif

  8. Click OK


  9. Keep the Process Options to Update

    9.gif

  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 

    10.gif

  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.

    11.gif

    And then click ok and again click ok.
You are through.

All Queries are welcome !!