Is it ok to process multiple partitions simultaneously using job schedule or
multiple running scripts? I know it cannot mix with processing dimension.
However, can all dimensions be processed simultaneously?

Yes, in fact, you might be interested in a utility which was written for
just this purpose.
Parallel Processing Utility -- does both dims and partitions
http://www.microsoft.com/downloads/d...DisplayLang=en
If you'd like to write your own, or sell the code inside the PPU, just look
at its source. It is included on the distribution.

Enjoy.
--
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.


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

In fact, what I do is just create multiple DTS package that process
partitions, and I simplely create jobs for every DTS package and let them run
simultaneously.

"Dave Wickert [MSFT]" wrote:

In simple situations that might work.
If it does for you, then great.
If you run into problems, look to use the PPU.
--
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.


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

Seems it's not 100% sure if simplely processing partitions simultaneously ok.
Does Microsoft have any documentation detail it?

My experience shows a lot of time it works. But sometime it fails for
various reason like server memory low or just an unknown error.

"Dave Wickert [MSFT]" wrote: