Share via


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.

See Also

Reference