Configuring Attribute Types
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.
Setting Attribute Types
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 Currency (Analysis Services - Multidimensional Data).
The following tables list the attribute types available in Analysis Services. These tables separate attribute types into the following categories:
Term |
Definition |
|---|---|
General attribute types |
These values are available to all attributes, and exist only to enable classification of attributes for client application purposes. |
Account dimension attribute types |
These values identify an attribute that belongs to an account dimension. For more information about account dimension, see Account (Analysis Services - Multidimensional Data). |
Currency dimension attribute type |
These values identify an attribute that belongs to a currency dimension. For more information about currency dimensions, see Currency (Analysis Services - Multidimensional Data). |
Slowly changing dimension attributes |
These values identify an attribute that belongs to a slowly changing dimension. |
Time dimension attributes |
These values identify an attribute that belongs to a time dimension. For more information about time dimensions, see Time (Analysis Services - Multidimensional Data). |
General Attribute Types
Attribute Type Value |
Description |
|---|---|
Address |
Represents an address. |
AddressBuilding |
Represents a building identifier for an address. |
AddressCity |
Represents a city for an address. |
AddressCountry |
Represents a country or region for an address. |
AddressFax |
Represents a fax telephone number. |
AddressFloor |
Represents a floor identifier for an address. |
AddressHouse |
Represents a house number for an address. |
AddressPhone |
Represents a telephone number. |
AddressQuarter |
Represents a quarter for an address. |
AddressRoom |
Represents a room identifier for an address. |
AddressStateOrProvince |
Represents a state or province for an address. |
AddressStreet |
Represents the street for an address. |
AddressZip |
Represents a ZIP Code or Postal Code for an address. |
BomResource |
Represents a resource for a bill of materials (BOM). |
Caption |
Represents a caption. |
CaptionAbbreviation |
Represents an abbreviation. |
CaptionDescription |
Represents a description. |
Channel |
Represents a channel. |
City |
Represents a city. |
Company |
Represents a company. |
Continent |
Represents a continent. |
Country |
Represents a country or region. |
County |
Represents a county. |
CustomerGroup |
Represents a group of customers. |
CustomerHousehold |
Represents a household of customers. |
Customers |
Represents a customer. |
DateCanceled |
Represents a cancellation date. |
DateDuration |
Represents a duration. |
DateEnded |
Represents an end date. |
DateModified |
Represents a modification date. |
DateStart |
Represents a start date. |
DeletedFlag |
Indicates whether a member is or should be deleted (in terms of business functionality.) .gif "Note") 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.
|
FormattingColor |
Represents the color used in formatting. |
FormattingFont |
Represents the font used in formatting. |
FormattingFontEffects |
Represents the font effects used in formatting. |
FormattingFontSize |
Represents the font size used in formatting. |
FormattingOrder |
Represents the order used in formatting. |
FormattingSubtotal |
Represents a subtotal. |
GeoBoundaryBottom |
Represents the bottommost value of a geographic boundary. |
GeoBoundaryFront |
Represents the value at the front of a geographic boundary. |
GeoBoundaryLeft |
Represents the leftmost value of a geographic boundary. |
GeoBoundaryPolygon |
Represents the polygon definition of a geographic boundary. |
GeoBoundaryRear |
Represents the rearmost value of a geographic boundary. |
GeoBoundaryRight |
Represents the rightmost value of a geographic boundary. |
GeoBoundaryTop |
Represents the topmost value of a geographic boundary. |
GeoCentroidX |
Represents an X-axis centroid for a geographic region. |
GeoCentroidY |
Represents a Y-axis centroid for a geographic region. |
GeoCentroidZ |
Represents a Z-axis centroid for a geographic region. |
ID |
Represents an identifier (ID) or key. |
Image |
Represents an image in an undefined graphic format. |
ImageBmp |
Represents an image in bitmap graphic format. |
ImageGif |
Represents an image in Graphics Interchange Format (GIF) graphic format. |
ImageJpg |
Represents an image in Joint Photographic Experts Group (JPEG) graphic format. |
ImagePng |
Represents an image in Portable Network Graphics (PNG) graphic format. |
ImageTiff |
Represents an image in Tagged Image File Format (TIFF) graphic format. |
OrganizationalUnit |
Represents an organizational unit. |
OrgTitle |
Represents an organizational title. |
PercentOwnership |
Represents a percent of ownership. |
PercentVoteRight |
Represents a percent of voting rights. |
Person |
Represents a person. |
PersonContact |
Represents contact information for a person. |
PersonDemographic |
Represents demographic information for a person. |
PersonFirstName |
Represents the first name of a person. |
PersonFullName |
Represents the full name of a person. |
PersonLastName |
Represents the surname (last name) of a person. |
PersonMiddleName |
Represents the middle name of a person. |
PhysicalColor |
Represents a color. |
PhysicalDensity |
Represents density. |
PhysicalDepth |
Represents depth. |
PhysicalHeight |
Represents height. |
PhysicalSize |
Represents a size. |
PhysicalVolume |
Represents volume. |
PhysicalWeight |
Represents weight. |
PhysicalWidth |
Represents width. |
Point |
Represents a point. |
PostalCode |
Represents a postal code. |
Product |
Represents a product. |
ProductBrand |
Represents a product brand. |
ProductCategory |
Represents a product category. |
ProductGroup |
Represents a product group. |
ProductSKU |
Represents a product stock keeping unit (SKU). |
Project |
Represents a project. |
ProjectCode |
Represents a project code. |
ProjectCompletion |
Represents the completion status of a project. |
ProjectEndDate |
Represents a project end date. |
ProjectName |
Represents a project name. |
ProjectStartDate |
Represents a project start date. |
Promotion |
Represents a promotion. |
QtyRangeHigh |
Represents the highest value of a range of quantities. |
QtyRangeLow |
Represents the lowest value of a range of quantities. |
Quantitative |
Represents a quantitative attribute. |
Rate |
Represents a rate. |
RateType |
Represents a rate type. |
Region |
Represents a customer-defined region. |
Regular |
Represents a regular attribute. |
RelationToParent |
Represents a relation to a parent. |
Representative |
Represents a representative. |
Scenario |
Represents a scenario. |
Sequence |
Represents a sequence attribute. |
ShortCaption |
Represents a short caption. |
StateOrProvince |
Represents a state or province. |
Utility |
Represents a utility. |
Version |
Represents a version. |
WebHtml |
Represents HTML content. |
WebMailAlias |
Represents an e-mail alias. |
WebUrl |
Represents a URL address. |
WebXmlOrXsl |
Represents XML or XSL content. |
Back to Setting Attribute Types
Account Dimension Attribute Types
Attribute Type Value |
Description |
|---|---|
Account |
Represents the parent of an account. This attribute type is typically applied to the parent attribute of an account dimension. |
AccountName |
Represents the name of an account. This attribute type is typically applied to the key attributes of an account dimension. |
AccountNumber |
Represents the number of an account. |
AccountType |
Represents 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. |
Back to Setting Attribute Types
Currency Dimension Attribute Types
Attribute Type Value |
Description |
|---|---|
CurrencyDestination |
Represents 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 - Multidimensional Data). |
CurrencyIsoCode |
Represents the International Standards Organization (ISO) code of a currency. For more information about currency conversion, see Currency Conversions (Analysis Services - Multidimensional Data). |
CurrencyName |
Represents the name of a currency. For more information about currency conversion, see Currency Conversions (Analysis Services - Multidimensional Data). |
CurrencySource |
Represents 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 - Multidimensional Data). |
Slowly Changing Dimension Attribute Types
Attribute Type Value |
Description |
|---|---|
ScdEndDate |
Represents the effective end date for a member in a slowly changing dimension. |
ScdOriginalID |
Represents the original identifier for a member in a slowly changing dimension. |
ScdStartDate |
Represents the effective start date for a member in a slowly changing dimension. |
ScdStatus |
Represents the effective status of a member in a slowly changing dimension. |
Back to Setting Attribute Types
Time Dimension Attribute Types
Attribute Type Value |
Description |
|---|---|
Date |
Represents a date. This attribute type is typically applied to the key attribute of a time dimension or server time dimension. |
DayOfHalfYear |
Represents the day ordinal of a half-year. |
DayOfMonth |
Represents the day ordinal of a month. |
DayOfQuarter |
Represents the day ordinal of a quarter. |
DayOfTenDays |
Represents the day ordinal of a ten-day period. |
DayOfTrimester |
Represents the day ordinal of a trimester. |
DayOfWeek |
Represents the day ordinal of a week. |
DayOfYear |
Represents the day ordinal of a year. |
Days |
Represents days. |
FiscalDate |
Represents a date in a fiscal calendar. |
FiscalDayOfHalfYear |
Represents the day ordinal of a half-year in a fiscal calendar. |
FiscalDayOfMonth |
Represents the day ordinal of a month in a fiscal calendar. |
FiscalDayOfQuarter |
Represents the day ordinal of a quarter in a fiscal calendar. |
FiscalDayOfTrimester |
Represents the day ordinal of a trimester in a fiscal calendar. |
FiscalDayOfWeek |
Represents the day ordinal of a week in a fiscal calendar. |
FiscalDayOfYear |
Represents the day ordinal of a year in a fiscal calendar. |
FiscalHalfYears |
Represents half-years in a fiscal calendar. |
FiscalHalfYearOfYear |
Represents the half-year ordinal of a year in a fiscal calendar. |
FiscalMonths |
Represents months in a fiscal calendar. |
FiscalMonthOfHalfYear |
Represents the month ordinal of a half-year in a fiscal calendar. |
FiscalMonthOfQuarter |
Represents the month ordinal of a quarter in a fiscal calendar. |
FiscalMonthOfTrimester |
Represents the month ordinal of a trimester in a fiscal calendar. |
FiscalMonthOfYear |
Represents the month ordinal of a year in a fiscal calendar. |
FiscalQuarters |
Represents quarters in a fiscal calendar. |
FiscalQuarterOfHalfYear |
Represents the quarter ordinal of a half-year in a fiscal calendar. |
FiscalQuarterOfYear |
Represents the quarter ordinal of a year in a fiscal calendar. |
FiscalTrimesters |
Represents trimesters in a fiscal calendar. |
FiscalTrimesterOfYear |
Represents the trimester ordinal of a year in a fiscal calendar. |
FiscalWeeks |
Represents weeks in a fiscal calendar. |
FiscalWeekOfHalfYear |
Represents the week ordinal of a half-year in a fiscal calendar. |
FiscalWeekOfMonth |
Represents the week ordinal of a month in a fiscal calendar. |
FiscalWeekOfQuarter |
Represents the week ordinal of a quarter in a fiscal calendar. |
FiscalWeekOfTrimester |
Represents the week ordinal of a trimester in a fiscal calendar. |
FiscalWeekOfYear |
Represents the week ordinal of a year in a fiscal calendar. |
FiscalYears |
Represents years in a fiscal calendar. |
HalfYears |
Represents half-years. |
HalfYearOfYear |
Represents the half-year ordinal of a year. |
Hours |
Represents hours. |
IsHoliday |
Indicates whether a date is a holiday. |
ISO8601Date |
Represents a date in an ISO 8601 calendar. |
ISO8601DayOfWeek |
Represents the day ordinal of a week in an ISO 8601 calendar. |
ISO8601DayOfYear |
Represents the day ordinal of a year in an ISO 8601 calendar. |
ISO8601Weeks |
Represents weeks in an ISO 8601 calendar. |
ISO8601WeekOfYear |
Represents the week ordinal of a year in an ISO 8601 calendar. |
ISO8601Years |
Represents years in an ISO 8601 calendar. |
IsPeakDay |
Indicates whether a date is a peak day. |
IsWeekDay |
Indicates whether a date is a weekday. |
IsWorkingDay |
Indicates whether a date is a working day. |
ManufacturingDate |
Represents a date in a manufacturing calendar. |
ManufacturingDayOfHalfYear |
Represents the day ordinal of a half-year in a manufacturing calendar. |
ManufacturingDayOfMonth |
Represents the day ordinal of a month in a manufacturing calendar. |
ManufacturingDayOfQuarter |
Represents the day ordinal of a quarter in a manufacturing calendar. |
ManufacturingDayOfTrimester |
Represents the day ordinal of a trimester in a manufacturing calendar. |
ManufacturingDayOfWeek |
Represents the day ordinal of a week in a manufacturing calendar. |
ManufacturingDayOfYear |
Represents the day ordinal of a year in a manufacturing calendar. |
ManufacturingHalfYears |
Represents half-years in a manufacturing calendar. |
ManufacturingHalfYearOfYear |
Represents the half-year ordinal of a year in a manufacturing calendar. |
ManufacturingMonths |
Represents months in a manufacturing calendar. |
ManufacturingMonthOfHalfYear |
Represents the month ordinal of a half-year in a manufacturing calendar. |
ManufacturingMonthOfQuarter |
Represents the month ordinal of a quarter in a manufacturing calendar. |
ManufacturingMonthOfTrimester |
Represents the month ordinal of a trimester in a manufacturing calendar. |
ManufacturingMonthOfYear |
Represents the month ordinal of a year in a manufacturing calendar. |
ManufacturingQuarters |
Represents quarters in a manufacturing calendar. |
ManufacturingQuarterOfHalfYear |
Represents the quarter ordinal of a half-year in a manufacturing calendar. |
ManufacturingQuarterOfYear |
Represents the quarter ordinal of a year in a manufacturing calendar. |
ManufacturingWeeks |
Represents weeks in a manufacturing calendar. |
ManufacturingWeekOfHalfYear |
Represents the week ordinal of a half-year in a manufacturing calendar. |
ManufacturingWeekOfMonth |
Represents the week ordinal of a month in a manufacturing calendar. |
ManufacturingWeekOfQuarter |
Represents the week ordinal of a quarter in a manufacturing calendar. |
ManufacturingWeekOfTrimester |
Represents the week ordinal of a trimester in a manufacturing calendar. |
ManufacturingWeekOfYear |
Represents the week ordinal of a year in a manufacturing calendar. |
ManufacturingYears |
Represents years in a manufacturing calendar. |
Minutes |
Represents minutes. |
Months |
Represents months. |
MonthOfHalfYear |
Represents the month ordinal of a half-year. |
MonthOfQuarter |
Represents the month ordinal of a quarter. |
MonthOfTrimester |
Represents the month ordinal of a trimester. |
MonthOfYear |
Represents the month ordinal of a year. |
Quarters |
Represents quarters. |
QuarterOfHalfYear |
Represents the quarter ordinal of a half-year. |
QuarterOfYear |
Represents the quarter ordinal of a year. |
ReportingDate |
Represents a date in a reporting calendar. |
ReportingDayOfHalfYear |
Represents the day ordinal of a half-year in a reporting calendar. |
ReportingDayOfMonth |
Represents the day ordinal of a month in a reporting calendar. |
ReportingDayOfQuarter |
Represents the day ordinal of a quarter in a reporting calendar. |
ReportingDayOfTrimester |
Represents the day ordinal of a trimester in a reporting calendar. |
ReportingDayOfWeek |
Represents the day ordinal of a week in a reporting calendar. |
ReportingDayOfYear |
Represents the day ordinal of a year in a reporting calendar. |
ReportingHalfYears |
Represents half-years in a reporting calendar. |
ReportingHalfYearOfYear |
Represents the half-year ordinal of a year in a reporting calendar. |
ReportingMonths |
Represents months in a reporting calendar. |
ReportingMonthOfHalfYear |
Represents the month ordinal of a half-year in a reporting calendar. |
ReportingMonthOfQuarter |
Represents the month ordinal of a quarter in a reporting calendar. |
ReportingMonthOfTrimester |
Represents the month ordinal of a trimester in a reporting calendar. |
ReportingMonthOfYear |
Represents the month ordinal of a year in a reporting calendar. |
ReportingQuarters |
Represents quarters in a reporting calendar. |
ReportingQuarterOfHalfYear |
Represents the quarter ordinal of a half-year in a reporting calendar. |
ReportingQuarterOfYear |
Represents the quarter ordinal of a year in a reporting calendar. |
ReportingTrimesters |
Represents trimesters in a reporting calendar. |
ReportingTrimesterOfYear |
Represents the trimester ordinal of a year in a reporting calendar. |
ReportingWeeks |
Represents weeks in a reporting calendar. |
ReportingWeekOfHalfYear |
Represents the week ordinal of a half-year in a reporting calendar. |
ReportingWeekOfMonth |
Represents the week ordinal of a month in a reporting calendar. |
ReportingWeekOfQuarter |
Represents the week ordinal of a quarter in a reporting calendar. |
ReportingWeekOfTrimester |
Represents the week ordinal of a trimester in a reporting calendar. |
ReportingWeekOfYear |
Represents the week ordinal of a year in a reporting calendar. |
ReportingYears |
Represents years in a reporting calendar. |
Seconds |
Represents seconds. |
TenDayOfHalfYear |
Represents the ten-day period ordinal of a half-year. |
TenDayOfMonth |
Represents the ten-day period ordinal of a month. |
TenDayOfQuarter |
Represents the ten-day period ordinal of a quarter. |
TenDayOfTrimester |
Represents the ten-day period ordinal of a trimester. |
TenDayOfYear |
Represents the ten-day period ordinal of a year. |
TenDays |
Represents ten-day periods. |
Trimesters |
Represents trimesters. |
TrimesterOfYear |
Represents the trimester ordinal of a year. |
UndefinedTime |
Represents an undefined time period. |
WeekOfYear |
Represents the week ordinal of a year. |
Weeks |
Represents weeks. |
WinterSummerSeason |
Indicates whether the date is part of the winter/summer season. |
Years |
Represents years. |
Back to Setting Attribute Types