TechNet
Export (0) Print
Expand All

Configure Attribute Types

 

Applies To: SQL Server 2016

In Microsoft SQL Server Analysis Services, attribute types help classify an attribute in terms of business functionality. There are many attribute types, most of which are used by client applications to display or support an attribute. However, some attribute types also have specific meaning to Analysis Services. For example, some attribute types identify attributes that represent time periods in various calendars for time dimensions.

The value of the Type property for an attribute determines the attribute type for that attribute. Several wizards in Analysis Services set attribute types when defining dimensions or attributes. These Analysis Services wizards also set attribute types when the wizards add functionality to dimensions. For example, the Business Intelligence Wizard applies several attribute types to attributes in a dimension when the wizard adds account intelligence to identify attributes that contain the names, codes, numbers, and structure of accounts in the dimension. The Business Intelligence Wizard also consumes attribute types, such as for currency conversion. For more information, see Create a Currency type Dimension.

The following tables list the attribute types available in Analysis Services. These tables separate attribute types into the following categories:

TermDefinition
General attribute typesThese values are available to all attributes, and exist only to enable classification of attributes for client application purposes.
Account dimension attribute typesThese values identify an attribute that belongs to an account dimension. For more information about account dimension, see Create a Finance Account of parent-child type Dimension.
Currency dimension attribute typeThese values identify an attribute that belongs to a currency dimension. For more information about currency dimensions, see Create a Currency type Dimension.
Slowly changing dimension attributesThese values identify an attribute that belongs to a slowly changing dimension.
Time dimension attributesThese values identify an attribute that belongs to a time dimension. For more information about time dimensions, see Create a Date type Dimension.

General Attribute Types

Attribute Type ValueDescription
AddressRepresents an address.
AddressBuildingRepresents a building identifier for an address.
AddressCityRepresents a city for an address.
AddressCountryRepresents a country or region for an address.
AddressFaxRepresents a fax telephone number.
AddressFloorRepresents a floor identifier for an address.
AddressHouseRepresents a house number for an address.
AddressPhoneRepresents a telephone number.
AddressQuarterRepresents a quarter for an address.
AddressRoomRepresents a room identifier for an address.
AddressStateOrProvinceRepresents a state or province for an address.
AddressStreetRepresents the street for an address.
AddressZipRepresents a ZIP Code or Postal Code for an address.
BomResourceRepresents a resource for a bill of materials (BOM).
CaptionRepresents a caption.
CaptionAbbreviationRepresents an abbreviation.
CaptionDescriptionRepresents a description.
ChannelRepresents a channel.
CityRepresents a city.
CompanyRepresents a company.
ContinentRepresents a continent.
CountryRepresents a country or region.
CountyRepresents a county.
CustomerGroupRepresents a group of customers.
CustomerHouseholdRepresents a household of customers.
CustomersRepresents a customer.
DateCanceledRepresents a cancellation date.
DateDurationRepresents a duration.
DateEndedRepresents an end date.
DateModifiedRepresents a modification date.
DateStartRepresents a start date.
DeletedFlagIndicates whether a member is or should be deleted (in terms of business functionality.)

Note: Analysis Services does not use this attribute type to determine whether a member should be deleted. Instead, this attribute type is intended to be used by client applications for display purposes only.
FormattingColorRepresents the color used in formatting.
FormattingFontRepresents the font used in formatting.
FormattingFontEffectsRepresents the font effects used in formatting.
FormattingFontSizeRepresents the font size used in formatting.
FormattingOrderRepresents the order used in formatting.
FormattingSubtotalRepresents a subtotal.
GeoBoundaryBottomRepresents the bottommost value of a geographic boundary.
GeoBoundaryFrontRepresents the value at the front of a geographic boundary.
GeoBoundaryLeftRepresents the leftmost value of a geographic boundary.
GeoBoundaryPolygonRepresents the polygon definition of a geographic boundary.
GeoBoundaryRearRepresents the rearmost value of a geographic boundary.
GeoBoundaryRightRepresents the rightmost value of a geographic boundary.
GeoBoundaryTopRepresents the topmost value of a geographic boundary.
GeoCentroidXRepresents an X-axis centroid for a geographic region.
GeoCentroidYRepresents a Y-axis centroid for a geographic region.
GeoCentroidZRepresents a Z-axis centroid for a geographic region.
IDRepresents an identifier (ID) or key.
ImageRepresents an image in an undefined graphic format.
ImageBmpRepresents an image in bitmap graphic format.
ImageGifRepresents an image in Graphics Interchange Format (GIF) graphic format.
ImageJpgRepresents an image in Joint Photographic Experts Group (JPEG) graphic format.
ImagePngRepresents an image in Portable Network Graphics (PNG) graphic format.
ImageTiffRepresents an image in Tagged Image File Format (TIFF) graphic format.
OrganizationalUnitRepresents an organizational unit.
OrgTitleRepresents an organizational title.
PercentOwnershipRepresents a percent of ownership.
PercentVoteRightRepresents a percent of voting rights.
PersonRepresents a person.
PersonContactRepresents contact information for a person.
PersonDemographicRepresents demographic information for a person.
PersonFirstNameRepresents the first name of a person.
PersonFullNameRepresents the full name of a person.
PersonLastNameRepresents the surname (last name) of a person.
PersonMiddleNameRepresents the middle name of a person.
PhysicalColorRepresents a color.
PhysicalDensityRepresents density.
PhysicalDepthRepresents depth.
PhysicalHeightRepresents height.
PhysicalSizeRepresents a size.
PhysicalVolumeRepresents volume.
PhysicalWeightRepresents weight.
PhysicalWidthRepresents width.
PointRepresents a point.
PostalCodeRepresents a postal code.
ProductRepresents a product.
ProductBrandRepresents a product brand.
ProductCategoryRepresents a product category.
ProductGroupRepresents a product group.
ProductSKURepresents a product stock keeping unit (SKU).
ProjectRepresents a project.
ProjectCodeRepresents a project code.
ProjectCompletionRepresents the completion status of a project.
ProjectEndDateRepresents a project end date.
ProjectNameRepresents a project name.
ProjectStartDateRepresents a project start date.
PromotionRepresents a promotion.
QtyRangeHighRepresents the highest value of a range of quantities.
QtyRangeLowRepresents the lowest value of a range of quantities.
QuantitativeRepresents a quantitative attribute.
RateRepresents a rate.
RateTypeRepresents a rate type.
RegionRepresents a customer-defined region.
RegularRepresents a regular attribute.
RelationToParentRepresents a relation to a parent.
RepresentativeRepresents a representative.
ScenarioRepresents a scenario.
SequenceRepresents a sequence attribute.
ShortCaptionRepresents a short caption.
StateOrProvinceRepresents a state or province.
UtilityRepresents a utility.
VersionRepresents a version.
WebHtmlRepresents HTML content.
WebMailAliasRepresents an e-mail alias.
WebUrlRepresents a URL address.
WebXmlOrXslRepresents XML or XSL content.

Account Dimension Attribute Types

Attribute Type ValueDescription
AccountRepresents the parent of an account. This attribute type is typically applied to the parent attribute of an account dimension.
AccountNameRepresents the name of an account. This attribute type is typically applied to the key attributes of an account dimension.
AccountNumberRepresents the number of an account.
AccountTypeRepresents the type of an account. This attribute type identifies the aggregation function of an account member in an account type dimension in the Analysis Services database.

Currency Dimension Attribute Types

Attribute Type ValueDescription
CurrencyDestinationRepresents the destination currency of a currency exchange. This attribute type is typically applied to the key attribute of a reporting dimension, for use in currency conversion. For more information about currency conversion, see Currency Conversions (Analysis Services).
CurrencyIsoCodeRepresents the International Standards Organization (ISO) code of a currency. For more information about currency conversion, see Currency Conversions (Analysis Services).
CurrencyNameRepresents the name of a currency. For more information about currency conversion, see Currency Conversions (Analysis Services).
CurrencySourceRepresents the source currency of a currency exchange. This attribute type is typically applied to the key attribute of a currency dimension, for use in currency conversion. For more information about currency conversion, see Currency Conversions (Analysis Services).

Slowly Changing Dimension Attribute Types

Attribute Type ValueDescription
ScdEndDateRepresents the effective end date for a member in a slowly changing dimension.
ScdOriginalIDRepresents the original identifier for a member in a slowly changing dimension.
ScdStartDateRepresents the effective start date for a member in a slowly changing dimension.
ScdStatusRepresents the effective status of a member in a slowly changing dimension.

Time Dimension Attribute Types

Attribute Type ValueDescription
DateRepresents a date. This attribute type is typically applied to the key attribute of a time dimension or server time dimension.
DayOfHalfYearRepresents the day ordinal of a half-year.
DayOfMonthRepresents the day ordinal of a month.
DayOfQuarterRepresents the day ordinal of a quarter.
DayOfTenDaysRepresents the day ordinal of a ten-day period.
DayOfTrimesterRepresents the day ordinal of a trimester.
DayOfWeekRepresents the day ordinal of a week.
DayOfYearRepresents the day ordinal of a year.
DaysRepresents days.
FiscalDateRepresents a date in a fiscal calendar.
FiscalDayOfHalfYearRepresents the day ordinal of a half-year in a fiscal calendar.
FiscalDayOfMonthRepresents the day ordinal of a month in a fiscal calendar.
FiscalDayOfQuarterRepresents the day ordinal of a quarter in a fiscal calendar.
FiscalDayOfTrimesterRepresents the day ordinal of a trimester in a fiscal calendar.
FiscalDayOfWeekRepresents the day ordinal of a week in a fiscal calendar.
FiscalDayOfYearRepresents the day ordinal of a year in a fiscal calendar.
FiscalHalfYearsRepresents half-years in a fiscal calendar.
FiscalHalfYearOfYearRepresents the half-year ordinal of a year in a fiscal calendar.
FiscalMonthsRepresents months in a fiscal calendar.
FiscalMonthOfHalfYearRepresents the month ordinal of a half-year in a fiscal calendar.
FiscalMonthOfQuarterRepresents the month ordinal of a quarter in a fiscal calendar.
FiscalMonthOfTrimesterRepresents the month ordinal of a trimester in a fiscal calendar.
FiscalMonthOfYearRepresents the month ordinal of a year in a fiscal calendar.
FiscalQuartersRepresents quarters in a fiscal calendar.
FiscalQuarterOfHalfYearRepresents the quarter ordinal of a half-year in a fiscal calendar.
FiscalQuarterOfYearRepresents the quarter ordinal of a year in a fiscal calendar.
FiscalTrimestersRepresents trimesters in a fiscal calendar.
FiscalTrimesterOfYearRepresents the trimester ordinal of a year in a fiscal calendar.
FiscalWeeksRepresents weeks in a fiscal calendar.
FiscalWeekOfHalfYearRepresents the week ordinal of a half-year in a fiscal calendar.
FiscalWeekOfMonthRepresents the week ordinal of a month in a fiscal calendar.
FiscalWeekOfQuarterRepresents the week ordinal of a quarter in a fiscal calendar.
FiscalWeekOfTrimesterRepresents the week ordinal of a trimester in a fiscal calendar.
FiscalWeekOfYearRepresents the week ordinal of a year in a fiscal calendar.
FiscalYearsRepresents years in a fiscal calendar.
HalfYearsRepresents half-years.
HalfYearOfYearRepresents the half-year ordinal of a year.
HoursRepresents hours.
IsHolidayIndicates whether a date is a holiday.
ISO8601DateRepresents a date in an ISO 8601 calendar.
ISO8601DayOfWeekRepresents the day ordinal of a week in an ISO 8601 calendar.
ISO8601DayOfYearRepresents the day ordinal of a year in an ISO 8601 calendar.
ISO8601WeeksRepresents weeks in an ISO 8601 calendar.
ISO8601WeekOfYearRepresents the week ordinal of a year in an ISO 8601 calendar.
ISO8601YearsRepresents years in an ISO 8601 calendar.
IsPeakDayIndicates whether a date is a peak day.
IsWeekDayIndicates whether a date is a weekday.
IsWorkingDayIndicates whether a date is a working day.
ManufacturingDateRepresents a date in a manufacturing calendar.
ManufacturingDayOfHalfYearRepresents the day ordinal of a half-year in a manufacturing calendar.
ManufacturingDayOfMonthRepresents the day ordinal of a month in a manufacturing calendar.
ManufacturingDayOfQuarterRepresents the day ordinal of a quarter in a manufacturing calendar.
ManufacturingDayOfTrimesterRepresents the day ordinal of a trimester in a manufacturing calendar.
ManufacturingDayOfWeekRepresents the day ordinal of a week in a manufacturing calendar.
ManufacturingDayOfYearRepresents the day ordinal of a year in a manufacturing calendar.
ManufacturingHalfYearsRepresents half-years in a manufacturing calendar.
ManufacturingHalfYearOfYearRepresents the half-year ordinal of a year in a manufacturing calendar.
ManufacturingMonthsRepresents months in a manufacturing calendar.
ManufacturingMonthOfHalfYearRepresents the month ordinal of a half-year in a manufacturing calendar.
ManufacturingMonthOfQuarterRepresents the month ordinal of a quarter in a manufacturing calendar.
ManufacturingMonthOfTrimesterRepresents the month ordinal of a trimester in a manufacturing calendar.
ManufacturingMonthOfYearRepresents the month ordinal of a year in a manufacturing calendar.
ManufacturingQuartersRepresents quarters in a manufacturing calendar.
ManufacturingQuarterOfHalfYearRepresents the quarter ordinal of a half-year in a manufacturing calendar.
ManufacturingQuarterOfYearRepresents the quarter ordinal of a year in a manufacturing calendar.
ManufacturingWeeksRepresents weeks in a manufacturing calendar.
ManufacturingWeekOfHalfYearRepresents the week ordinal of a half-year in a manufacturing calendar.
ManufacturingWeekOfMonthRepresents the week ordinal of a month in a manufacturing calendar.
ManufacturingWeekOfQuarterRepresents the week ordinal of a quarter in a manufacturing calendar.
ManufacturingWeekOfTrimesterRepresents the week ordinal of a trimester in a manufacturing calendar.
ManufacturingWeekOfYearRepresents the week ordinal of a year in a manufacturing calendar.
ManufacturingYearsRepresents years in a manufacturing calendar.
MinutesRepresents minutes.
MonthsRepresents months.
MonthOfHalfYearRepresents the month ordinal of a half-year.
MonthOfQuarterRepresents the month ordinal of a quarter.
MonthOfTrimesterRepresents the month ordinal of a trimester.
MonthOfYearRepresents the month ordinal of a year.
QuartersRepresents quarters.
QuarterOfHalfYearRepresents the quarter ordinal of a half-year.
QuarterOfYearRepresents the quarter ordinal of a year.
ReportingDateRepresents a date in a reporting calendar.
ReportingDayOfHalfYearRepresents the day ordinal of a half-year in a reporting calendar.
ReportingDayOfMonthRepresents the day ordinal of a month in a reporting calendar.
ReportingDayOfQuarterRepresents the day ordinal of a quarter in a reporting calendar.
ReportingDayOfTrimesterRepresents the day ordinal of a trimester in a reporting calendar.
ReportingDayOfWeekRepresents the day ordinal of a week in a reporting calendar.
ReportingDayOfYearRepresents the day ordinal of a year in a reporting calendar.
ReportingHalfYearsRepresents half-years in a reporting calendar.
ReportingHalfYearOfYearRepresents the half-year ordinal of a year in a reporting calendar.
ReportingMonthsRepresents months in a reporting calendar.
ReportingMonthOfHalfYearRepresents the month ordinal of a half-year in a reporting calendar.
ReportingMonthOfQuarterRepresents the month ordinal of a quarter in a reporting calendar.
ReportingMonthOfTrimesterRepresents the month ordinal of a trimester in a reporting calendar.
ReportingMonthOfYearRepresents the month ordinal of a year in a reporting calendar.
ReportingQuartersRepresents quarters in a reporting calendar.
ReportingQuarterOfHalfYearRepresents the quarter ordinal of a half-year in a reporting calendar.
ReportingQuarterOfYearRepresents the quarter ordinal of a year in a reporting calendar.
ReportingTrimestersRepresents trimesters in a reporting calendar.
ReportingTrimesterOfYearRepresents the trimester ordinal of a year in a reporting calendar.
ReportingWeeksRepresents weeks in a reporting calendar.
ReportingWeekOfHalfYearRepresents the week ordinal of a half-year in a reporting calendar.
ReportingWeekOfMonthRepresents the week ordinal of a month in a reporting calendar.
ReportingWeekOfQuarterRepresents the week ordinal of a quarter in a reporting calendar.
ReportingWeekOfTrimesterRepresents the week ordinal of a trimester in a reporting calendar.
ReportingWeekOfYearRepresents the week ordinal of a year in a reporting calendar.
ReportingYearsRepresents years in a reporting calendar.
SecondsRepresents seconds.
TenDayOfHalfYearRepresents the ten-day period ordinal of a half-year.
TenDayOfMonthRepresents the ten-day period ordinal of a month.
TenDayOfQuarterRepresents the ten-day period ordinal of a quarter.
TenDayOfTrimesterRepresents the ten-day period ordinal of a trimester.
TenDayOfYearRepresents the ten-day period ordinal of a year.
TenDaysRepresents ten-day periods.
TrimestersRepresents trimesters.
TrimesterOfYearRepresents the trimester ordinal of a year.
UndefinedTimeRepresents an undefined time period.
WeekOfYearRepresents the week ordinal of a year.
WeeksRepresents weeks.
WinterSummerSeasonIndicates whether the date is part of the winter/summer season.
YearsRepresents years.

Attributes and Attribute Hierarchies
Dimension Attribute Properties Reference

Community Additions

ADD
Show:
© 2016 Microsoft