I know you can use the ParallelProcess utility to process
cubes/partitions in parallel. However, I would like to
automate the parallel processing using the command line. I
believe this is done with ProcessPartition.exe, but I have
not been able to find any examples of this.

Are there any examples of how to automate the parallel
process of partitions?

Thanks in advance!

The parallel process utility has s command line interface. There should be
documentation with the utility that explains how to do it.

Sean


--
Sean

--
Sean Boon
SQL Server BI Product Unit

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.

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

Sean is right -- also it would be better to use the command-line option of
ParallelProcess.exe. If you call ProcessPartition by-hand, you will have to
implement your own parallelization and workload management scheme.

Using ParallelProcess via command-line is easy. You can create a
configuration interactively, and then actually do the 'processing' of that
workload by calling ParallelProcess from the command-line (see readme.doc
for more info). ParallelProcss will then schedule and parallelize individual
runs of ProcessPartition, just as if you were running it interactively. Read
the readme.doc file carefully. There are some restrictions, such as the
scheduling agent (WinAT, SQL Agent, etc.) must be running under an NT
account that is included in the OLAP Administrators group on the Analsyis
server.
--
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.


"Sean Boon [MS]" <seanboon (AT) online (DOT) microsoft.com> wrote