SQL Server Business Intelligence

SQL SERVER 2005 & 2008 IS THE MAIN THEME OF THIS BLOG

Monday, February 13, 2006

Incremental Cube Processing

AS2005 will NOT process aggregations automatically when you process the partition. During used partition processing it used to process the data and it also built the aggregations for that partition. It is changed in AS2005. You can process partition incrementally using "Process Incremental" option. If you want to build index you have to do that using "Process Index" option.

If you wish, you can put these two in 2 separate steps within SSIS after data is loaded.

Its all about how quickly you want the data presented to the users. If you do the Process Incremental first and made the data available for users first and then build the aggregations while users are using the data. This way will give you maximum availability, but impacts performance while building aggregations and indices. UI in SSMS does not support "Process Incremental" and "Process Index" in one single transaction. You can achieve that using simple XMLA scripts as shown below:
http://www.smart-bi-solutions.com/BlogStuff/incremental_process.xmla

This example uses Adventure Works. ProcessAdd and ProcessIndexes are the key things to look out for in the XMLA doc.

Thanks
Sutha

2 Comments:

  • At 6:48 AM, Blogger ESTEBAN ALVINO Q. said…

    I am reviewing your post, i need to make a process incremental, my input paramaters are periods, i hope your post could me help.

    Thanks !!!!

    =)

     
  • At 4:09 AM, Blogger Sutha Thiru said…

    I dont think I understand the question. This paper might help you. If you need further help please let me know.

    http://msdn2.microsoft.com/en-us/library/ms345142.aspx

    Thanks
    Sutha

     

Post a Comment

<< Home