DimensionTypes
[!NOTA]
Questa caratteristica verrà rimossa a partire dalla prossima versione di Microsoft SQL Server. Non utilizzare questa caratteristica in un nuovo progetto di sviluppo e modificare non appena possibile le applicazioni in cui è attualmente implementata.
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. |