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