SourceTableAlias (MDStore Interface)
.gif "ms132767.note(de-de,SQL.90).gif") Hinweis: |
|---|
| Dieses Feature wird in der nächsten Version von Microsoft SQL Server entfernt. Verwenden Sie dieses Feature nicht zum Entwickeln neuer Anwendungen, und planen Sie das Ändern von Anwendungen, in denen es zurzeit verwendet wird, zum frühstmöglichen Zeitpunkt ein. |
The SourceTableAlias property of the MDStore interface contains the alias of the source table for the cube or partition.
Applies To:clsCube, clsPartition
Data Type
String
Access
Read-write
Hinweise
If the source table has no alias, the contents of this property are identical to those of the SourceTable property.
Examples
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"