Configuring Attribute Types

In Microsoft SQL Server 2005 Analysis Services (SSAS), 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).

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 (SSAS).
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).
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 (SSAS).

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.)

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 Working with Currency Conversions (SSAS).
CurrencyIsoCode	Represents the International Standards Organization (ISO) code of a currency. For more information about currency conversion, see Working with Currency Conversions (SSAS).
CurrencyName	Represents the name of a currency. For more information about currency conversion, see Working with Currency Conversions (SSAS).
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 Working with Currency Conversions (SSAS).

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

See Also

Concepts

Attributes and Attribute Hierarchies
Defining and Configuring Dimension Attributes

Help and Information

Getting SQL Server 2005 Assistance