DependsOnDimension (Dimension Interface)
[!참고]
이 기능은 다음 버전의 Microsoft SQL Server에서 제거됩니다. 새 개발 작업에서는 이 기능을 사용하지 말고, 현재 이 기능을 사용하는 응용 프로그램은 가능한 한 빨리 수정하십시오.
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 |
주의
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.