SourceTable (Dimension Interface)

注意：
下一版本的 Microsoft SQL Server 将删除该功能。请不要在新的开发工作中使用该功能，并尽快修改当前还在使用该功能的应用程序。

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

备注

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.

示例

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

请参阅

参考

Dimension Interface

帮助和信息

获取 SQL Server 2005 帮助