SSAS 2008 Cube processing option

Hi Amit,

Please let me know if i go for "Process Default" option for processing the partition cube then does this also process all dimensions or only the measure.

What is the best approach for cube processing?

Regards,

Pallavi

Hi Pallavi,

Process Default or Process Full can trigger dimension processing only if there are any Dimensions in unprocessed state. Remember, "Impact Analysis" option in the processing dialog box may not always show that. For example, try unprocessing any dimension in your solution, then process your cube or any partition that contains that dimension, choose Process Default or Full and observe that the dimension processing is triggered. So it really depends in what state your objects are.

the best approach for cube processing? "It depends" :), but some tips can be as follows:

If you have ran Process update on your diemnsion, then the aggregations in cube get invalidated. Running process default on the cube can rebuilt those aggregations.

Process Full is the easiest option but very time-consuming for large cubes so if you really need to do it, then only deply chaanges from BIDS and do the processing from SSMS, so that you can continue working in BIDS while the processing happens in background.

Process Data & Process Index can be done in seperately to better utilize the memory but this best practice needs to be tested if it really gives you benefit considering your hardware.

Lazy Aggregations are not recommended for performance reasons even though it can make cube available faster.

New Partitions will go under Process Default/Full.

So as you see a lot depends on your project.

Hope you got some insight. Also focus on Dimension Processing at the same time...

Regards

Amit

Thanks Amit....the information provided is of great help !

Hello Amit,

I processed all my dimensions and realised that my Cube is not longer accessible. Does processing the dimensions drop the cube??

what processing option did you use to process your dimension?