I want to incrementally process the cube from my DTS script. I already have
a script, in which I have the following code:

if (processOption = 0) then ' 0 = full process

if DEBUGMODE Then MsgBox "Full process cube: " +
dsoCube.Name

dsoCube.Process 1 '
ProcessTypes.processFull = 1

else

' 1
= incremental process

dsoCube.Process 0

end if



Right now, am just refreshing the whole cube, since I cudn't find an option
in ProcessTypes to incrementally update the cube. Can anyone send me a code
snippet, which can illustrate incremental processing? Note that I cannot
purge my fact table, since I need to have drill through functionality as
well



Regards,

Ali

There is no direct support for incremental partition processing in DSO. What
you have to do is to clone the partition to a temporary partition (name
starts with ~), modify it's properties (for example, adding a filter
clause), process the cloned partition, and then merge the two partitions
back together.

If you want to see an example of how to do it, look at the Parallel
Processing Utility source (in particular, look at the ProcessPartition.exe
source).
http://www.microsoft.com/downloads/d...DisplayLang=en

Hope that helps.
--
Dave Wickert [MS]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Practices Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"Ali [Xavor]" <alishahzadbutt (AT) hotmail (DOT) com> wrote

Why not just use the Incremental Update option of the AS Processing Task
available in DTS? Or am I missing something here?

Les M


"Dave Wickert [MSFT]" <dwickert (AT) online (DOT) microsoft.com> wrote in
news:#N67IIyGEHA.3788 (AT) TK2MSFTNGP09 (DOT) phx.gbl:

You can, but it does the same thing under the covers that I mentioned in my
previous post -- it creates a temporary partition, does the incremental
process; then merges the partition.
--
Dave Wickert [MS]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Practices Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"Les McPhee" <mcphee69 (AT) hotmail (DOT) com> wrote