LevelTypes

  • Article

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 LevelType property.

Constant Description

levAccount

Indicates that a level exists within an account dimension.

levAll

Indicates the top (All) level of a dimension (the one that precalculates all the members of all lower levels).

levBOMResource

Indicates that a level is part of a bill of materials dimension.

levChannel

Indicates that a level exists within a distribution channel dimension.

levCompany

Indicates that a level contains information about a company.

levCurrencyDestination

Indicates that a level contains information about the resulting currency after a foreign exchange conversion.

levCurrencySource

Indicates that a level contains information about the starting currency before a foreign exchange conversion.

levCustomer

Indicates that a level contains information about an individual customer.

levCustomerGroup

Indicates that a level contains information about a customer group.

levCustomerHousehold

Indicates that a level contains information about an entire household.

levGeoCity

Indicates that a level refers to a city name.

levGeoContinent

Indicates that a level refers to a continent name.

levGeoCountry

Indicates that a level refers to a country or region name.

levGeoCounty

Indicates that a level refers to a county name.

levGeoPoint

Indicates that a level refers to a location type that does not fit into the other geographic categories.

levGeoPostalCode

Indicates that a level refers to a postal code.

levGeoRegion

Indicates that a level refers to a custom-defined region.

levGeoStateOrProvince

Indicates that a level refers to a state or province name.

levOrgUnit

Indicates that a level refers to the name of a unit within a larger organization.

levPerson

Indicates that a level refers to an individual within a larger organization.

levProduct

Indicates that a level refers to an individual product.

levProductGroup

Indicates that a level refers to a product group.

levPromotion

Indicates that a level refers to a promotion.

levQuantitative

Indicates that a level refers to a quantitative member within a quantitative dimension.

levRegular

Indicates that the level is not related to time.

levRepresentative

Indicates that a level refers to a sales representative.

levScenario

Indicates that a level refers to a scenario.

levTimeDays

Indicates that a level refers to days. It must be used in a dimension whose type is dimTime.

levTimeHalfYears

Indicates that a level refers to half-years. It must be used in a dimension whose type is dimTime.

levTimeHours

Indicates that a level refers to hours. It must be used in a dimension whose type is dimTime.

levTimeMinutes

Indicates that a level refers to minutes. It must be used in a dimension whose type is dimTime.

levTimeMonths

Indicates that a level refers to months. Must be used in a dimension whose type is dimTime.

levTimeQuarters

Indicates that a level refers to (calendar) quarters. It must be used in a dimension whose type is dimTime.

levTimeSeconds

Indicates that a level refers to seconds. It must be used in a dimension whose type is dimTime.

levTimeUndefined

Indicates that a level refers to an indeterminate or nonstandard measurement of time. It must be used in a dimension whose type is dimTime.

levTimeWeeks

Indicates that a level refers to weeks. It must be used in a dimension whose type is dimTime.

levTimeYears

Indicates that a level refers to years. It must be used in a dimension whose type is dimTime.

levUtility

Indicates that a level refers to a calculated member in a utility dimension.