I am using MS BI Accelerator created cubes and DTS packages and receive DSO
error messages saying "Object variable or With block variable not set" when
running updates.

Looking at other threads in this forum, it appears there is a Analysis
Services Parallel Processing Utility that resolves this.

Is there any guidance for how to modify the DTS scripts to use this utility?
Or, are there any BI Accelerator patches out there that I can use?

Thanks,
Bill

You are certainly welcome to use the PPU to do processing rather than the BI
Accelerator.
What version of the BI Accelerator are you using? V1.2 has fixed several
bugs and requires a post-SP3 hotfix which addresses many of these "object
variable not set" errors during cube/partition/dim processing.

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

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

Hi Dave. Yes, I am using 1.2 -- build 1.2.1125.0 (17-June-2003)

Where can I find the post-SP3 hotfix that you mention?

Thanks,
Bill



"Dave Wickert [MSFT]" wrote:

It is listed in the 1.2 release notes.
--
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.

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

I used the same BI tool version 1.2
I changed the global parameters to SKIP PROCESSING OF DIMENSIONS AND CUBES.
I created SEPARATE DTS Packages (one for each dimension and one for each cube)
so in sql agent job, I call these dts packages separately to process
dimensions first
and then the cubes.

if you use dts, you can specify incremental or full process of dimension and
cubes...

This seems to help a lot because the transactions are isolated and
smaller...and I have more control over the processing....although it is still
sequential...the next step is to use the parallel processing utility mention
elsewhere on msdn to process the dimensions and cubes and partition in
parallel.



"Dave Wickert [MSFT]" wrote: