我使用DSO创建了数据立方的新分区,如何更改它的事实表?
dsoMainPartition = New DSO.Partition
dsoNewPartition = New DSO.Partition
On Error GoTo Err_AddPartition
dsoNewPartition = dsoCube.MDStores.AddNew(strNewPartition)
dsoMainPartition = dsoCube.MDStores.Item("smalltestcube") '.Item
dsoMainPartition.Clone(dsoNewPartition)
'更新新分区的事实表
With dsoNewPartition
.SourceTable = strNewFact
.FromClause = Replace(dsoMainPartition.FromClause, dsoMainPartition.SourceTable, dsoNewPartition.SourceTable)
.JoinClause = Replace(dsoMainPartition.JoinClause, dsoMainPartition.SourceTable, dsoNewPartition.SourceTable)
End With
上述语句事实上没有更新我设置的事实表strNewFact,而还是dsoMainPartition对应的事实表。
请问如何设置才能更改新分区的事实表? 参与有分!