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
to process 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

You look at the Parallel Processing Utility. It includes source; or you
might be able to use it as-is:
http://www.microsoft.com/downloads/d...DisplayLang=en
Also, you look at the AS Performance Guide:
http://www.microsoft.com/technet/pro.../ansvcspg.mspx
And the AS Operations Guide:
http://www.microsoft.com/technet/pro.../anservog.mspx
Both have information on how to optimize processing.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Sajith" <Sajith (AT) discussions (DOT) microsoft.com> wrote