DimensionTypes
.gif "ms134805.note(zh-tw,SQL.90).gif") 附註： |
|---|
| 下一版的 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. |