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.

备注

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.

请参阅

参考

Dimension Interface

概念

Working with Virtual Dimensions

帮助和信息

获取 SQL Server 2005 帮助