Type Element (DimensionAttribute) (ASSL)

 

Applies To: SQL Server 2016 Preview

Contains the type of the attribute.

  
<DimensionAttribute>  
      ...  
   <Type>...</Type>  
   ...  
</DimensionAttribute>  

CharacteristicDescription
Data type and lengthString (enumeration)
Default valueRegular
Cardinality0-1: Optional element that can occur once and only once.
RelationshipElement
Parent elementDimensionAttribute
Child elementsNone

The value of this element is limited to one of the strings listed in the following table.

ValueDescription
AccountThe attribute represents the name of an account.
AccountNumberThe attribute represents the number of an account.
AccountTypeThe attribute represents the type of an account.
AddressThe attribute represents an address.
AddressBuildingThe attribute represents a building identifier for an address.
AddressCityThe attribute represents a city for an address.
AddressCountryThe attribute represents a country or region for an address.
AddressFaxThe attribute represents a fax telephone number.
AddressFloorThe attribute represents a floor identifier for an address.
AddressHouseThe attribute represents a house number for an address.
AddressPhoneThe attribute represents a telephone number.
AddressQuarterThe attribute represents a quarter for an address.
AddressRoomThe attribute represents a room identifier for an address.
AddressStateOrProvinceThe attribute represents a state or province for an address.
AddressStreetThe attribute represents the street for an address.
AddressZipThe attribute represents a postal code (ZIP code) for an address.
BOMResourceThe attribute represents a resource for a bill of materials (BOM).
CaptionThe attribute represents a caption.
CaptionAbbreviationThe attribute represents an abbreviation.
CaptionDescriptionThe attribute represents a description.
ChannelThe attribute represents a channel.
CityThe attribute represents a city.
CompanyThe attribute represents a company.
ContinentThe attribute represents a continent.
CountryThe attribute represents a country or region.
CountyThe attribute represents a county.
CurrencyDestinationThe attribute represents the destination currency of a currency exchange.
CurrencyISOcodeThe attribute represents the ISO code of a currency.
CurrencNameThe attribute represents the name of a currency.
CurrencySourceThe attribute represents the source currency of a currency exchange.
CustomerGroupThe attribute represents a group of customers.
CustomerHouseholdThe attribute represents a household of customers.
CustomersThe attribute represents a customer.
DateThe attribute represents a date.
DateCanceledThe attribute represents a cancellation date.
DateDurationThe attribute represents a duration.
DateEndedThe attribute represents an end date.
DateModifiedThe attribute represents a modification date.
DateStartThe attribute represents a start date.
DayOfHalfYearsThe attribute represents the day ordinal of a half-year.
DayOfMonthThe attribute represents the day ordinal of a month.
DayOfQuarterThe attribute represents the day ordinal of a quarter.
DayOfTrimesterThe attribute represents the day ordinal of a trimester.
DayOfWeekThe attribute represents the day ordinal of a week.
DayOfYearThe attribute represents the day ordinal of a year.
DaysThe attribute represents days.
DaysOfTenDaysThe attribute represents the day ordinal of a ten-day period.
FiscalDayThe attribute represents days in a fiscal calendar.
FiscalDayOfHalfYearsThe attribute represents the day ordinal of a half-year in a fiscal calendar.
FiscalDayOfMonthThe attribute represents the day ordinal of a month in a fiscal calendar.
FiscalDayOfQuarterThe attribute represents the day ordinal of a quarter in a fiscal calendar.
FiscalDayOfTrimesterThe attribute represents the day ordinal of a trimester in a fiscal calendar.
FiscalDayOfWeekThe attribute represents the day ordinal of a week in a fiscal calendar.
FiscalDayOfYearThe attribute represents the day ordinal of a year in a fiscal calendar.
FiscalHalfYearsThe attribute represents half-years in a fiscal calendar.
FiscalHalfYearsOfYearThe attribute represents the half-year ordinal of a year in a fiscal calendar.
FiscalMonthThe attribute represents months in a fiscal calendar.
FiscalMonthOfHalfYearsThe attribute represents the month ordinal of a half-year in a fiscal calendar.
FiscalMonthOfQuarterThe attribute represents the month ordinal of a quarter in a fiscal calendar.
FiscalMonthOfTrimesterThe attribute represents the month ordinal of a trimester in a fiscal calendar.
FiscalMonthOfYearThe attribute represents the month ordinal of a year in a fiscal calendar.
FiscalQuarterThe attribute represents quarters in a fiscal calendar.
FiscalQuarterOfHalfYearThe attribute represents the quarter ordinal of a half-year in a fiscal calendar.
FiscalQuarterOfYearThe attribute represents the quarter ordinal of a year in a fiscal calendar.
FiscalTrimesterThe attribute represents trimesters in a fiscal calendar.
FiscalTrimesterOfYearThe attribute represents the trimester ordinal of a year in a fiscal calendar.
FiscalWeekThe attribute represents weeks in a fiscal calendar.
FiscalWeekOfHalfYearsThe attribute represents the week ordinal of a half-year in a fiscal calendar.
FiscalWeekOfMonthThe attribute represents the week ordinal of a month in a fiscal calendar.
FiscalWeekOfQuarterThe attribute represents the week ordinal of a quarter in a fiscal calendar.
FiscalWeekOfTrimesterThe attribute represents the week ordinal of a trimester in a fiscal calendar.
FiscalWeekOfYearThe attribute represents the week ordinal of a year in a fiscal calendar.
FiscalYearThe attribute represents years in a fiscal calendar.
FormattingColorThe attribute represents the color used in formatting.
FormattingFontThe attribute represents the font used in formatting.
FormattingFontEffectsThe attribute represents the font effects used in formatting.
FormattingFontSizeThe attribute represents the font size used in formatting.
FormattingOrderThe attribute represents the order used in formatting.
FormattingSubtotalThe attribute represents a subtotal.
GeoBoundaryBottomThe attribute represents the bottommost value of a geographic boundary.
GeoBoundaryFrontThe attribute represents the frontmost value of a geographic boundary.
GeoBoundaryLeftThe attribute represents the leftmost value of a geographic boundary.
GeoBoundaryPolygonThe attribute represents the polygon definition of a geographic boundary.
GeoBoundaryRearThe attribute represents the rearmost value of a geographic boundary.
GeoBoundaryRightThe attribute represents the rightmost value of a geographic boundary.
GeoBoundaryTopThe attribute represents the topmost value of a geographic boundary.
GeoCentroidXThe attribute represents an X-axis centroid for a geographic region.
GeoCentroidYThe attribute represents a Y-axis centroid for a geographic region.
GeoCentroidZThe attribute represents a Z-axis centroid for a geographic region.
HalfYearsThe attribute represents half-years.
HalfYearsOfYearThe attribute represents the half-year ordinal of a year.
HoursThe attribute represents hours.
IdThe attribute represents an identifier or key.
IsHolidayThe attribute indicates whether a date is a holiday.
ISO8601DayOfWeekThe attribute represents the day ordinal of a week in an ISO 8601 calendar.
ISO8601DayOfYearThe attribute represents the day ordinal of a year in an ISO 8601 calendar.
ISO8601DaysThe attribute represents days in an ISO 8601 calendar.
ISO8601WeekThe attribute represents weeks in an ISO 8601 calendar.
ISO8601WeekOfYearThe attribute represents the week ordinal of a year in an ISO 8601 calendar.
ISO8601YearThe attribute represents years in an ISO 8601 calendar.
IsWeekDayThe attribute indicates whether a date is a weekday.
IsWorkingDayThe attribute indicates whether a date is a working day.
ManufacturingDayThe attribute represents days in a manufacturing calendar.
ManufacturingDayOfHalfYearsThe attribute represents the day ordinal of a half-year in a manufacturing calendar.
ManufacturingDayOfMonthThe attribute represents the day ordinal of a month in a manufacturing calendar.
ManufacturingDayOfQuarterThe attribute represents the day ordinal of a quarter in a manufacturing calendar.
ManufacturingDayOfTrimesterThe attribute represents the day ordinal of a trimester in a manufacturing calendar.
ManufacturingDayOfWeekThe attribute represents the day ordinal of a week in a manufacturing calendar.
ManufacturingDayOfYearThe attribute represents the day ordinal of a year in a manufacturing calendar.
ManufacturingHalfYearsThe attribute represents half-years in a manufacturing calendar.
ManufacturingHalfYearsOfYearThe attribute represents the half-year ordinal of a year in a manufacturing calendar.
ManufacturingMonthThe attribute represents months in a manufacturing calendar.
ManufacturingMonthOfHalfYearsThe attribute represents the month ordinal of a half-year in a manufacturing calendar.
ManufacturingMonthOfQuarterThe attribute represents the month ordinal of a quarter in a manufacturing calendar.
ManufacturingMonthOfTrimesterThe attribute represents the month ordinal of a trimester in a manufacturing calendar.
ManufacturingMonthOfYearThe attribute represents the month ordinal of a year in a manufacturing calendar.
ManufacturingQuarterThe attribute represents quarters in a manufacturing calendar.
ManufacturingQuarterOfHalfYearThe attribute represents the quarter ordinal of a half-year in a manufacturing calendar.
ManufacturingQuarterOfYearThe attribute represents the quarter ordinal of a year in a manufacturing calendar.
ManufacturingTrimesterThe attribute represents trimesters in a manufacturing calendar.
ManufacturingTrimesterOfYearThe attribute represents the trimester ordinal of a year in a manufacturing calendar.
ManufacturingWeekThe attribute represents weeks in a manufacturing calendar.
ManufacturingWeekOfHalfYearsThe attribute represents the week ordinal of a half-year in a manufacturing calendar.
ManufacturingWeekOfMonthThe attribute represents the week ordinal of a month in a manufacturing calendar.
ManufacturingWeekOfQuarterThe attribute represents the week ordinal of a quarter in a manufacturing calendar.
ManufacturingWeekOfTrimesterThe attribute represents the week ordinal of a trimester in a manufacturing calendar.
ManufacturingWeekOfYearThe attribute represents the week ordinal of a year in a manufacturing calendar.
ManufacturingYearThe attribute represents years in a manufacturing calendar.
MinutesThe attribute represents minutes.
MonthOfHalfYearsThe attribute represents the month ordinal of a half-year.
MonthOfQuarterThe attribute represents the month ordinal of a quarter.
MonthOfTrimesterThe attribute represents the month ordinal of a trimester.
MonthOfYearThe attribute represents the month ordinal of a year.
MonthsThe attribute represents months.
OrganizationalUnitThe attribute represents an organizational unit.
OrgTitleThe attribute represents an organizational title.
PercentOwnershipThe attribute represents a percent of ownership.
PercentVoteRightThe attribute represents a percent of voting rights.
PersonThe attribute represents a person.
PersonContactThe attribute represents contact information for a person.
PersonDemographicThe attribute represents demographic information for a person.
PersonFirstNameThe attribute represents the given name (first name) of a person.
PersonFullNameThe attribute represents the full name of a person.
PersonLastNameThe attribute represents the surname (last name) of a person.
PersonMiddleNameThe attribute represents the middle name of a person.
PhysicalColorThe attribute represents a color.
PhysicalDensityThe attribute represents density.
PhysicalDepthThe attribute represents depth.
PhysicalHeightThe attribute represents height.
PhysicalSizeThe attribute represents a size.
PhysicalVolumeThe attribute represents volume.
PhysicalWeightThe attribute represents weight.
PhysicalWidthThe attribute represents width.
PointThe attribute represents a point.
PostalCodeThe attribute represents a postal code.
ProductThe attribute represents a product.
ProductBrandThe attribute represents a product brand.
ProductCategoryThe attribute represents a product category.
ProductGroupThe attribute represents a product group.
ProductSKUThe attribute represents a product stock keeping unit (SKU).
ProjectCodeThe attribute represents a project code.
ProjectcompletionThe attribute represents the completion status of a project.
ProjectEnddateThe attribute represents a project end date.
ProjectNameThe attribute represents a project name.
ProjectStartDateThe attribute represents a project start date.
PromotionThe attribute represents a promotion.
QtyRangeHighThe attribute represents the highest value of a range of quantities.
QtyRangeLowThe attribute represents the lowest value of a range of quantities.
QuantitativeThe attribute represents a quantitative attribute.
QuarterOfHalfYearThe attribute represents the quarter ordinal of a half-year.
QuarterOfYearThe attribute represents the quarter ordinal of a year.
QuartersThe attribute represents quarters.
RateThe attribute represents a rate.
RateTypeThe attribute represents a rate type.
RegionThe attribute represents a customer-defined region.
RegularThe attribute represents a regular attribute.
RelationToParentThe attribute represents a relation to a parent.
ReportingDayThe attribute represents days in a reporting calendar.
ReportingDayOfHalfYearsThe attribute represents the day ordinal of a half-year in a reporting calendar.
ReportingDayOfMonthThe attribute represents the day ordinal of a month in a reporting calendar.
ReportingDayOfQuarterThe attribute represents the day ordinal of a quarter in a reporting calendar.
ReportingDayOfTrimesterThe attribute represents the day ordinal of a trimester in a reporting calendar.
ReportingDayOfWeekThe attribute represents the day ordinal of a week in a reporting calendar.
ReportingDayOfYearThe attribute represents the day ordinal of a year in a reporting calendar.
ReportingHalfYearsThe attribute represents half-years in a reporting calendar.
ReportingHalfYearsOfYearThe attribute represents the half-year ordinal of a year in a reporting calendar.
ReportingMonthThe attribute represents months in a reporting calendar.
ReportingMonthOfHalfYearsThe attribute represents the month ordinal of a half-year in a reporting calendar.
ReportingMonthOfQuarterThe attribute represents the month ordinal of a quarter in a reporting calendar.
ReportingMonthOfTrimesterThe attribute represents the month ordinal of a trimester in a reporting calendar.
ReportingMonthOfYearThe attribute represents the month ordinal of a year in a reporting calendar.
ReportingQuarterThe attribute represents quarters in a reporting calendar.
ReportingQuarterOfHalfYearThe attribute represents the quarter ordinal of a half-year in a reporting calendar.
ReportingQuarterOfYearThe attribute represents the quarter ordinal of a year in a reporting calendar.
ReportingTrimesterThe attribute represents trimesters in a reporting calendar.
ReportingTrimesterOfYearThe attribute represents the trimester ordinal of a year in a reporting calendar.
ReportingWeekThe attribute represents weeks in a reporting calendar.
ReportingWeekOfHalfYearsThe attribute represents the week ordinal of a half-year in a reporting calendar.
ReportingWeekOfMonthThe attribute represents the week ordinal of a month in a reporting calendar.
ReportingWeekOfQuarterThe attribute represents the week ordinal of a quarter in a reporting calendar.
ReportingWeekOfTrimesterThe attribute represents the week ordinal of a trimester in a reporting calendar.
ReportingWeekOfYearThe attribute represents the week ordinal of a year in a reporting calendar.
ReportingYearThe attribute represents years in a reporting calendar.
RepresentativeThe attribute represents a representative.
ScenarioThe attribute represents a scenario.
SecondsThe attribute represents seconds.
SequenceThe attribute represents a sequence attribute.
ShortCaptionThe attribute represents a short caption.
StateOrProvinceThe attribute represents a state or province.
TenDayOfHalfYearsThe attribute represents the ten-day period ordinal of a half-year.
TenDayOfQuarterThe attribute represents the ten-day period ordinal of a quarter.
TenDayOfTrimesterThe attribute represents the ten-day period ordinal of a trimester.
TenDayOfYearThe attribute represents the ten-day period ordinal of a year.
TenDaysThe attribute represents ten-day periods.
TenDaysOfMonthThe attribute represents the ten-day period ordinal of a month.
TrimesterThe attribute represents trimesters.
TrimesterOfYearThe attribute represents the trimester ordinal of a year.
UndefinedTimeThe attribute represents an undefined time period.
UtilityThe attribute represents a utility.
VersionThe attribute represents a version.
WebHtmlThe attribute represents HTML content.
WebMailAliasThe attribute represents an e-mail alias.
WebUrlThe attribute represents a URL address.
WebXmlOrXslThe attribute represents XML or XSL content.
WeekOfHalfYearsThe attribute represents the week ordinal of a half-year.
WeekOfMonthThe attribute represents the week ordinal of a month.
WeekOfQuarterThe attribute represents the week ordinal of a quarter.
WeekOfTrimesterThe attribute represents the week ordinal of a trimester.
WeekOfYearThe attribute represents the week ordinal of a year.
WeeksThe attribute represents weeks.
YearsThe attribute represents years.

The enumeration that corresponds to the allowed values for Type in the Analysis Management Objects (AMO) object model is AttributeType.

The element that corresponds to the parent of Type in the Analysis Management Objects (AMO) object model is DimensionAttribute.

Attributes Element (ASSL)
Dimension Element (ASSL)
Properties (ASSL)

Community Additions

ADD
Show: