DimensionTypes

注意：
下一版本的 Microsoft SQL Server 将删除该功能。请不要在新的开发工作中使用该功能，并尽快修改当前还在使用该功能的应用程序。

Enumerates values for the DimensionType property.

Constant	Description
dimAccounts	Describes a dimension that contains an accounts structure with parent-child relationships.
dimBillOfMaterials	Describes a dimension that represents a material/component breakdown. The parent-child relationship implies a parent composed of its children.
dimChannel	Describes a dimension that contains information about a distribution channel.
dimCurrency	Describes a dimension that contains currency information.
dimCustomers	Describes a dimension that contains customer information. The lowest level represents individual customers.
dimGeography	Describes a dimension that contains a geographic hierarchy.
dimOrganization	Describes a dimension that represents the reporting structure of an organization.
dimProducts	Describes a dimension that contains product information. The lowest level represents individual products.
dimPromotion	Describes a dimension that contains information about marketing and advertising promotions.
dimQuantitative	Describes a dimension that contains quantitative elements (for example, income level, number of children, and so on).
dimRates	Describes a dimension that contains different types of rates (for example, buy, sell, discounted. and so on).
dimRegular	The default dimension type, used for dimensions that are not time-related.
dimScenario	Describes a dimension that contains different business scenarios.
dimTime	Indicates that a dimension refers to time (year, month, week, day, and so on). The only valid levels in a time dimension are those that begin with "levTime" as defined in the LevelTypes enumeration.
dimUtility	Describes a dimension that contains only calculated members. This type of dimension is usually used for data visualization techniques.

请参阅

参考

LevelTypes

帮助和信息

获取 SQL Server 2005 帮助