I have a question about which processing option should be used for SSAS dimensions.
I heard that ProcessFull option is faster than ProcessUpdate, and I found that it is the case. I have a big dimension of a cube, which takes about 90 mins to process using ProcessUpdate, took only 40 minutes by using ProcessFull. Time is saved by half!
Also, given at some point of time of dimension processing, ProcessFull would be necessary, then why should ProcessUpdate be used at all? The AI gives the following answer:
The reason to use ProcessUpdate instead of ProcessFull for SSAS dimensions is to save processing time. ProcessFull is faster than ProcessUpdate, but it drops all data in the dimension and then processes the dimension, which means that all affected cubes and their partitions will exist in an unprocessed state and they will have to be fully processed on their next scheduled run.
But I found the answer even more confusing:
- If the use of of "ProcessUpdate" is to "save processing time", then how come "ProcessUpdate" is slower?
- If the cube (i.e its measure groups) would be processed fully after all its dimensions have been processed anyway, does it matter if "ProcessUpdate" or "ProcessFull"?