DSO processSuspend prevents cube processing? -
07-26-2004
, 02:14 PM
I'm trying to write a DSO package that:
- Suspends user queries to a cube
- Fiddles with cube's writeback table and one (MOLAP) partition's fact
table
- Processes that partition
- Resumes queries to the cube
I've got the package written, using the DSO Process method with the
processSuspend and processResume process types. However, in testing
the package it appears that processSuspend also prevents processing of
a partition in addition to suspending user queries. Can anyone confirm
that this is the case? If so, is there a way to accomplish what I'm
looking to do?
If not, my plan is to convert the partition to a real-time ROLAP
partition so it won't need processing, but I'm reluctant to do this
because of possible query performance degradation. |