Hi,

As our cube database volume is big, we have created partitions in each cube.
Now we have around 18 partitions in each cube. One database have around 34
cubes. We have scheduled everything through DTS. It is taking around 3 hours
for a database.

I have read in one of the article that using DSO objects will make
processing fast. Please advice.

Also please tell me any link to article so that i can get the example VB
code for Incremental Processing of a partition using DSO objects.

Thanks in advance
With best regards
Sajith

I haven't tested the performance between OLAP task and DSO. But I'm
sure both are the same, Anyway here is the code for incremental
update.]

sPartName = '<<name of partition>>'
Set dsoPartition = dsoCube.MDStores(sPartName)

Set dsoTmpPartition = dsoCube.MDStores.AddNew("~" &
sPartName)

dsoPartition.Clone dsoTmpPartition
dsoTmpPartition.SourceTableFilter = '<<set filter to fact
table>>'
dsoTmpPartition.Update

dsoTmpPartition.Process processFull

' dsoTmpPartition.SourceTableFilter = "" 'Uncomment if you
require
dsoTmpPartition.Update

dsoPartition.Merge "~" & sPartName


Regards,
Arun