Hi All,

I have a big problem setting SourceTable property of just cloned partition
using DSO (in AS2000). Cloning partition from the cube's main partition
works, setting SourceTableFilter works, processing partition works fine too.
Before I do partition update and processing, I need to change SourceTable
property of the new cloned partition. But when I assign new source table name
to this property, the property holds the same old value! I don't even get any
error message!

This is part of the C# code:

DSO.MDStore oPartition = (DSO.MDStore)
oCube.MDStores.AddNew("~temp",DSO.SubClassTypes.sb clsRegular);
DSO.MDStore CubePartition = (DSO.MDStore) oCube.MDStores.Item(oCube.Name);
CubePartition.Clone(oPartition, DSO.CloneOptions.cloneMajorChildren);

oPartition.SourceTable = "\"dbo\".\"AnotherSourceTable\""; // this is simply
not working

This last assignment to SourceTable property proceeds without any error, but
the property still holds the old value! I even tried to change oPartition
object type to DSO.PartitionClass and used hidden member "set_FactTable(ref
string)" to set the property, but with no success.
There is a plenty of VB code, but I haven't seen any DSO code in C# about
this. It might sound weird, but is it possible that there is some internal
problem because C# doesn't support Variant type?

Desperately need help on this!

Gustav

Problem solved. SourceTable property won't change until you change also
FromClause property. Nice. :-/

"Gustav Elsner" wrote: