DimensionTypes
Note
This feature will be removed in the next version of Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible.
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. |