dbTalk Databases Forums  

DSO processSuspend prevents cube processing?

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss DSO processSuspend prevents cube processing? in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Martin Neuliep
 
Posts: n/a

Default 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.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.