SourceTableAlias (MDStore Interface)
This feature will be removed in the next version of Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible.
The SourceTableAlias property of the MDStore interface contains the alias of the source table for the cube or partition.
Setting the SourceTable and SourceTable Alias Properties
The following example shows how to set the SourceTable and SourceTableAlias properties:
' Assume that an MDStore object dsoCube exists ' If the FromClause property for the cube is: ' "customer, store, sales_fact_1997 AS Sales" ' Set the SourceTable property to the actual name of the table dsoCube.SourceTable = "sales_fact_1997" ' And set the SourceTableAlias property to the name of the alias dsoCube.SourceTableAlias = "Sales"