SourceTable (Dimension Interface)

Note

  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 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

Remarks

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.

Example

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

See Also

Reference

Dimension Interface

Help and Information

Getting SQL Server 2005 Assistance