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 の参考資料の入手