Hi,

I have a SQL Server 2k DTS that processes a set of AS 2k OLAP cubes via a
scheduled job.

The cubes are currently processed one after each other, which is taking far
too long.

Can someone please tell me how I can process the cubes (in a DTS) in parallel.

Many Thanks

Jon Derbyshire

Hello Jon,

Analysis Services Parallel Processing Utility

http://www.microsoft.com/downloads/d...displaylang=en


hopefully this helps
Jörg



"Jon Derbyshire" wrote:

processing AS2000 cubes using DTS and the cube process task is not possible.
this task is NOT multithreaded.
if fact the DSO objects are not multithreaded, so you can do 2 actions at
the same time in the same process.

the parrallel process utility bypass this "problem" by executing multiple
process, each process execute 1 action against your AS2000 databases.

with AS2005 there is no more problems, by default the server process more
then 1 aggregation / cube / dimension at the same time. Really efficient!

"Jon Derbyshire" <JonDerbyshire (AT) discussions (DOT) microsoft.com> wrote