Jaa


AllowSiblingsWithSameName (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 AllowSiblingsWithSameName property of the Dimension interface determines whether children of a single member in a hierarchy can have identical names.

Applies To:clsAggregationDimension, clsCubeDimension, clsDatabaseDimension, clsPartitionDimension

Data Type

Boolean

Access

Access depends on the value of the ClassType property of the object.

Class type Access

clsDatabaseDimension

R/W

clsCubeDimension

R

clsPartitionDimension

R

clsAggregationDimension

R

Remarks

If this property is set to True, different members of a dimension can have identical names and positions. The members are distinguished by their key values. For example, two John Smiths may live in Seattle. In this case, the members are siblings because they are children of the same parent member, Seattle. If you set this property to True, the Analysis server disambiguates the members using their key values rather than raising an error.

Example

The following example creates a dimension called Customers and sets its AllowSiblingsWithSameName property to True:

'Assume an object (dsoDimCust) of ClassType clsDatabase exists.
Dim dsoDimCust As DSO.Dimension
Set dsoDimCust = dsoDB.Dimensions.AddNew("Customer")
DsoDimCust.AllowSiblingsWithSameName = TRUE

See Also

Reference

Dimension Interface

Help and Information

Getting SQL Server 2005 Assistance