In this thread: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=580892&SiteID=1 Edward told me that doing a ProcessUpdate of your dimensions causes the indexes and aggregations of all your partitions that use those dimensions to get dropped.
I am really worried about this. Does this mean that I have to manually rebuild all my indexes and on ALL partitions after I have done the ProcessUpdate or is it done for me?
Another worry is that if I have a big fact table this could take a long long long time. In fact I'm not just worried, that is a huge risk in my book.
Could soeone fill me in as to what happens with the indexes and aggs after they are dropped.
Thanks
Jamie
This is known and well documented situation. Most of the references talk about AS 2000, but pretty much the same logic applies to AS 2005 as well:
http://support.microsoft.com/Default.aspx?kbid=896864
http://blogs.msdn.com/bi_systems/articles/187701.aspx
you can search more about flexible aggregations and lazy processing.
In short solution to this situation is following:
1. As part of ProcessUpdate command for processing your dimensions you can specify ProcessAffectedObjects flag on the processing command. It is exposed as check box in the processing dialog.
If you select this option, the partition's aggregations and indexes are going to be rebuild as part of the same command you submitting.
2. You can turn on Lazy processing ( see Analysis Server configuraiton options whitepaper ) and Analysis Server is going to rebuild your aggregations and indexes in the backgroud after ProcessUpdate for the dimension is done.
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
No comments:
Post a Comment