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?