LevelTypes

Observaçã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 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.