DependsOnDimension (Dimension Interface)

Analysis Services Programming

Analysis Services Programming

DependsOnDimension (Dimension Interface)

The DependsOnDimension property of the Dimension interface contains the name of a dimension to which the current dimension depends.

Applies To

clsAggregationDimension

clsCubeDimension

clsDatabaseDimension

clsPartitionDimension

Data Type

String

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

The value of this property tells the Analysis server that the contents of the current dimension are dependent on the contents of another dimension. The Analysis server uses this property to more accurately predict the size of cubes and better optimize the design of aggregations.

Usually, a dimension is related to another dimension if the two represent different aspects of the same entity. For example, if the Customers dimension contains ten customers and the Customer Gender dimension contains two genders, the cross product contains only ten customer-gender combinations (no customer is measured once as male and once as female). In this case, the Customer Gender dimension depends on the Customers dimension. In contrast, if there are five items in the Products dimension, the cross product of Products and Customers contains a maximum of fifty customer-product combinations. In this case, Customers and Products are independent dimensions.

The property has different implications for virtual dimensions (those with the IsVirtual property set to True). The DependsOnDimension property for a virtual dimension contains the name of the underlying source dimension. All of the member key columns in the virtual dimension must appear in the source dimension.

See Also

Dimension Interface

Dependent Dimensions

Virtual Dimensions