For the benefit of others, as I just spent a day banging my head against this
particular brick wall until installing VB6 on a spare machine and getting the
scripting utility to work:

The problem appears to be that not only do you have to update the
FromClause / JoinClause for the cube, but you also have to do so for the
partition - eg, in pseudo-C#:

DSO.Cube cube = dsoDatabase.MDStores.Item( "SomeCube" );
DSO.Dimension dimension = cube.Dimensions( "SomeDimension" );

cube.Dimensions.Remove( dimension );
// A cube with a single partition has one with the same name as the cube.
// On the Enterprise version you can have multiple partitions
// This code assumes a single partition
DSO.Partition partition = cube.Partitions.Item( "SomeCube" ) ;

cube.FromClause = CalculateNewFromClause();
cube.JoinClause = CalculateNewJoinClause();

partition.FromClause = cube.FromClause;
partition.JoinClause = cube.JoinClause;

This is also applicable to adding dimensions to the cube.

Pete Appleton

Keywords for search: DSO decision support objects add remove adding
removing dimension cube partition

"Dave Wickert [MSFT]" wrote: