You certainly can do this, however, it's very difficult to determine if it's
the right thing to do for you without more information.
I'd recommend that first process your shared dimensions individually first.
Then you can process your cubes by processing partitions in parallel, etc.
How many partitions you can process in parallel at a faster rate than if you
processed them individually is a function of how many processors you have,
and how much memory is available.
I'd recommend that you read the following whitepaper and go from there.
Typically it's about 1 partition per 2 processors.
http://www.microsoft.com/technet/tre...e/ANSvcsPG.asp
--
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.
"Sundance" <anonymous (AT) discussions (DOT) microsoft.com> wrote
Quote:
I was wondering if it is possible to perform a full
process of more than one cube at a time? Would this be
ill advised? Any information related to this topic would
be greatly appreciated. Thanks. |