Hello. I'm doing DSO work in a VB6 app going to an Analysis Services 2000
cube (I know, a little behind the times). Meta data and fact/dimension data
are in SQL 2000; storage mode is MOLAP.

My app creates a ~ prefixed temporary partition in code and merges it back
to the main partition (incremental process). I get error: "Partitions
cannot be merged because the source and target partitions have a different
number of aggregations". Yet the new data is in AS and it's correct.

Do you think I can ignore this error or is something going to break down the
line?

TIA
Ken Trock

I have a VBScript on my blog that illustrates copying aggregations from
one partition to another. If you use this code as a basis you could
setup your new partition with the same aggregations as your main
partition it should merge OK.

--
Regards
Darren Gosbell - SQL Server MVP
Blog: http://www.geekswithblogs.net/darrengosbell

In article <8207E875-C155-4548-AEE1-2EDA03859BC7 (AT) microsoft (DOT) com>,
ktrock (AT) discussions (DOT) microsoft.com says...

Hi Ken,

This sounds similar to the post I made some time ago, Check out:
http://groups.google.ca/group/micros... febe9e7cb2df8

Barry

Barry, thanks for the code. It appears in the PartitonsOld area you're
purposely merging an empty partition back into the main one. That causes an
error on the 2nd try. For sure every temporary partition we create has plenty
of data in it. So I'm not sure if we're having the same exact same problem
you were but close.

Ken

"barry.hensch.nospam (AT) gmail (DOT) com" wrote: