Share via

  • Articolo

LevelTypes

[!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 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.