SourceTable (Dimension Interface)
.gif "ms134782.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 SourceTable property of the Dimension interface contains the name of a dimension object's primary source table.
Applies To:clsCubeDimension, clsDatabaseDimension, clsPartitionDimension
Data Type
String
Access
Read-only
Hinweise
This property returns the name of the source table associated with the lowest level in the dimension. For example, if your cube has a dimension called Product, and the dimension has levels called ProductCategory, ProductSubCategory, and ProductName, with ordinal positions 1, 2, and 3, respectively, the SourceTable property for the Product dimension returns the name of the source table associated with level ProductName.
Beispiel
Use the following code to obtain the name of the source table associated with level ProductName in dimension Product:
'Assume an object (dsoDim) of ClassType clsDimension exists.
If dsoDim.SourceTable = "Product" Then
'Insert code to handle the dimension.
End If