Is it possible to process dimensions in parallel in DSO?

The problem we're having is that we have to do an incremental update of our
dimensions every hour. This dimensional update takes about seven minutes
whereas the loading of the facts in the cube takes about a minute. We have
about ten dimensions to update, and 85% of the time is due to two
dimensions. I'd like to process these two dimensions in parallel rather than
serially. Is this something I can do within DSO? If this can be done I could
save about three minutes on the hourly job, a very big deal.



Our code looks like this:

Function ProcessDims(oDB)
Dim sDim
Dim iError, i
Dim tStart, tEnd

Err.Clear
On Error Resume Next

For i = 1 To oDB.Dimensions.Count
' rem: lo: only the dims that are in the cube
sDim = "": sDim = oDB.Dimensions(i).Name
tStart = Now
' Debug.Print odb.Dimensions(sDim).Name
oDB.Dimensions(sDim).Process 0
iError = Err
tEnd = Now

If iError <> 0 Then
ProcessDims = False
MetaLog "Process dimension " & sDim & " failed -- error " &
iError, 0, tStart, tEnd, Null, Null, Null, -1
Exit Function
Else
If igDebug > 0 Then
MetaLog "Dimension " & sDim & " processed ", 1, tStart,
tEnd, Null, Null, Null, -1
End If
End If
Next

ProcessDims = True
End Function

Yes you can process in parallel.
--
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.


"Jesse O" <jesperzz (AT) hotmail (DOT) com> wrote