DimensionTypes
Notes
Cette fonctionnalité sera supprimée dans la prochaine version de Microsoft SQL Server. Évitez d'utiliser cette fonctionnalité dans de nouveaux travaux de développement, et modifiez dès que possible les applications qui utilisent actuellement cette fonctionnalité.
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. |