I have a cube with a shared dimension of the form::
dimension Name: Document_Name
Level = Document Names

On a Daily basis I collect new data and attempt to do the following:

Incrementally Process the Document_Name dimension (to add new document
names)
Incrementally Process The Cube containing this dimension

I am working with COM-interop against DSO using C#:

The "Incremental Dimension Update" has the form:
given
DSO.Dimension y

I call:
y.Process(DSO.ProcessTypes.processRefreshData)



Question 1: Does DSO.ProcessTypes.processRefreshData function as a DIMENSION
Incremental Process?

and this completes successfully

"Incrementally Cube Update" has the form:

Given:
DSO.Cube c
I do the following
DSO.Partition Partition;
DSO.Partition ClonePartition;
string basename;
string tmpname;
basename=c.Name;
tmpname=string.Format("~New {0} Data",basename);
try{
Partition=(DSO.Partition) c.Partitions.Item(basename);

ClonePartition=(DSO.Partition)c.Partitions.AddNew( tmpname,DSO.SubClassTypes.
sbclsRegular);

Partition.Clone((DSO._ICommon)ClonePartition,DSO.C loneOptions.cloneMinorChil
dren);
ClonePartition.Process(DSO.ProcessTypes.processFul l);
Partition.Merge(tm);
}
catch(Exception e){
//do something here
}



All is well until the Partition.Merge statement. I receive an exception at
this point:

The aggregations of partition 'X' have been changed (the aggregations are
different).

QUESTION 2:

IS THIS is this a warning or an error?



thanks.

Dennis:

Do you create the initial data partition using DSO as well?

I have experienced this same error when I use DSO to create a
partition but do not put any data into initially. If you place at
least one row you should be fine. Check out my post from Dec 2, 2002
(Re: Analysis Services Partition Incremental Update using DSO) for
more info.

Barry
---------------------------

"Dennis Redfield" <dennis.redfield (AT) acadia-ins (DOT) com> wrote

Hi Dennis,

Thanks for your post. The processRefreshData option used in the Process
method is as a DIMENSION Incremental Process. ProcessRefreshData option
causes the dimension object data to be refreshed (that is, discarded and
repopulated), but does not change the object's structure. This operation
occurs inside a transaction, allowing users to continue using current data
while the transaction takes place. After the transaction is committed, the
new data is available.

For additional information regarding the process method, please refer to
the following article.
Process (Dimension Interface)
http://msdn.microsoft.com/library/de...us/olapdmpr/pr
dimensioni_7f03.asp

As the second problem, does Barry's suggestion address your problem? I
found the article he mentioned below:
Analysis Services Partition Incremental Update using DSO
http://dbforums.com/arch/67/2002/12/584920

Also, I would like you to apply the latest Service Pack for Analysis
Services on your side.
Microsoft SQL Server 2000 Service Pack 3a
http://www.microsoft.com/sql/downloads/2000/sp3.asp

Please feel free to post in the group if this solves your problem or if you
would like further assistance.

Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

thanks to both Barry and Michael. The train is running again.....

"Michael Shao [MSFT]" <v-yshao (AT) online (DOT) microsoft.com> wrote