AllowSiblingsWithSameName (Dimension Interface)

Analysis Services Programming

Analysis Services Programming

AllowSiblingsWithSameName (Dimension Interface)

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

Dimension Interface