I'm trying to programmatically process a set of AS objects and running into
a problem. My code currently loops through all of the shared dimensions in
a database, processing each using the processDefault type. Then, I want to
run through a list of partitions, incrementally updating each based on a
filter used on each partitions underlying fact table. When I try to process
the first partition (after successfully creating a temp partition to hold
the incremental data), I get the following error (this is the
Err.Description value -- I'm working in VBScript):

Dimension 'xyz' was processed in the same transaction

I believe this is being caused by the fact that I am wrapping this whole
operation in a transaction using the BeginTrans method on the database. I'd
like to do this so that if any of the incremental partition updates fail, I
can rollback the whole transaction so that none of the partition updates AND
none of the dimension updates are saved.

Is this possible?

Thanks for any thoughts...

Dave Fackler

can't DTS do this with a wizard?


"Dave Fackler" <davef (AT) intellinet (DOT) com> wrote