DimensionTypes
.gif "ms134805.note(de-de,SQL.90).gif") Hinweis: |
|---|
| Dieses Feature wird in der nächsten Version von Microsoft SQL Server entfernt. Verwenden Sie dieses Feature nicht zum Entwickeln neuer Anwendungen, und planen Sie das Ändern von Anwendungen, in denen es zurzeit verwendet wird, zum frühstmöglichen Zeitpunkt ein. |
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. |