Jaa


IsShared (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 IsShared property of the Dimension interface indicates whether a dimension object can be shared among multiple MDStore objects.

Applies To:clsAggregationDimension, clsCubeDimension, clsDatabaseDimension, clsPartitionDimension

Data Type

Boolean

Access

Read-only

Remarks

DSO sets the IsShared property by reading the Name property of the Dimension object. A dimension that is private to a cube has a name of the form MyCube^MyDim, where MyCube is the cube that contains the dimension. A dimension object that can be shared does not have the cube name as a prefix.

The value of the IsShared dimension of a database property is inherited by the associated cubes (and their partitions, aggregations, and virtual cubes).

Example

Use the following code to determine whether a dimension object can be shared with other dimension objects:

'Assume an object (dsoDim) of ClassType clsDatabaseDimension exists.
Dim bShared As Boolean
bShared = dsoDim.IsShared
If bShared Then
    'Insert code for a shared dimension.
Else
    'Insert code for a private dimension.
End If

See Also

Reference

Dimension Interface

Help and Information

Getting SQL Server 2005 Assistance