What's the best practice to do full processing of the cube?

thomaszhwang used Ask the Experts™
I have a huge cube that requires the entire day to do full processing.  At the same time, the cube does incremental process every hour, so the users can see the latest data within an hour.

The problem now is we are having more and more cube definition updates which requires to do full processing on the cube.  Although the cube is still available while the full processing is working, the hourly process will have to be stopped.  That means if the full processing requires a whole day to process, the data in the cube would be one day late.  

Any idea to resolve this issue?
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Director, Information Systems
Get faster/more capable hardware.

Spread the job out (don't ask me how) among multiple machines.

Prioritize the data that gets processed.  Process more important data more often.



Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial