I have created a script which clones a cube and replaces the existing
Fact table with a new one. The script works fine and sets up the
required joins and adds the new fact table as required, the only issue
is that the original fact table is still in the schema as well as a
normal table. Is anyone aware of how to resolve this?

Any help would be appreciated. I have provided a part of the script
below.

Thanks


---------------------------------------
VBScript being used
---------------------------------------

dsoCube.Clone dsoCubeNew

dsoCubeNew.SourceTable = strFactTable

' Set the FromClause and JoinClause properties of the new partition.

dsoCubeNew.FromClause = Replace(dsoCubeNew.FromClause,
dsoCube.SourceTable, dsoCubeNew.SourceTable)

dsoCubeNew.JoinClause = Replace(dsoCubeNew.JoinClause,
dsoCube.SourceTable, dsoCubeNew.SourceTable)

dsoCubeNew.update