We're using AMO to process our cubes and dimensions in SSAS2005.

We'll have a job that will run from five minutes to 13 hours depending on
how much data there is to process. If the job fails ten hours into it, the
transaction rolls back and we have to start from the beginning. This is NOT
what we want.

I'd like to avoid this. How can this be done in AMO?

anyone?

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

For instance, this processes all the dimensions in the cube. If one of the
updates fail, they all rollback. I'd like to change it to allow each
successful process before the failure to committ.


For Each oDimension In objCube.Dimensions

Try

If strKeepProcessing = "False" Then Exit Sub

oDimension.Dimension.Process(ProcessType.ProcessUp date)

Catch

strKeepProcessing = "False"

End Try

Next oDimension





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