Partilhar via


DimensionTypes

ObservaçãoObservação

  Esse recurso será removido na próxima versão do Microsoft SQL Server. Não utilize esse recurso em desenvolvimentos novos e modifique, assim que possível, os aplicativos que atualmente o utilizam.

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.

Consulte também

Referência