DataItem Data Type (ASSL)

Defines a primitive data type that represents the data-related characteristics of a data item, such as a column or attribute.

Syntax

<DataItem>
   <DataType>...</DataType>
   <DataSize>...</DataSize>
   <MimeType>...</MimeType>
   <NullProcessing>...</NullProcessing>
   <Trimming>...</Trimming>
   <InvalidXmlCharacters>...</InvalidXmlCharacters>
      <Collation>...</Collation>
   <Format>...</Format>
   <Source>...</Source>
   <Annotations>...</Annotations>
</DataItem>

Data Type Characteristics

Characteristic	Description
Base data types	None
Derived data types	None

Data Type Relationships

Relationship	Element
Parent elements	None
Child elements	Annotations, Collation, DataSize, DataType, Format, InvalidXmlCharacters, MimeType, NullProcessing, Source, Trimming
Derived elements	See the table in Remarks.

Remarks

The DataItem data type is used for any data item that can be bound; for example, a measure, attribute key, and attribute name. The details that are relevant, and the defaults that apply, depend on the usage; for example, attribute names must be strings.

An instance of Microsoft SQL Server 2005 Analysis Services (SSAS) accepts only a certain set of data types. Use of other data types results in an error, rather than an implicit conversion to one of the valid types.

The following table lists elements of type DataItem.

Parent Element	Element of type DataItem	Comments
AttributeTranslation	CaptionColumn	Source element of the DataItem must be of type ColumnBinding or AttributeBinding
DimensionAttribute	CustomRollupColumn	Source element of the DataItem must be of type ColumnBinding or AttributeBinding
DimensionAttribute	CustomRollupPropertiesColumn	Source element of the DataItem must be of type ColumnBinding or AttributeBinding
DimensionAttribute	KeyColumn	Source element of the DataItem must be of type ColumnBinding, AttributeBinding or TimeBinding
DimensionAttribute	NameColumn	Source element of the DataItem must be of type ColumnBinding or AttributeBinding
DimensionAttribute	SkippedLevelsColumn	Source element of the DataItem must be of type ColumnBinding or AttributeBinding
DimensionAttribute	UnaryOperatorColumn	Source element of the DataItem must be of type ColumnBinding or AttributeBinding
Measure	Source	Source element of the DataItem must be of type RowBinding, ColumnBinding, MeasureBinding, or CubeDimensionBinding
MeasureGroupAttribute	KeyColumn	Source element of the DataItem must be of type ColumnBinding, AttributeBinding or InheritedBinding
ScalarMiningStructureColumn	KeyColumn	Source element of the DataItem must be of type ColumnBinding
ScalarMiningStructureColumn	NameColumn	Source element of the DataItem must be of type ColumnBinding
TableMiningStructureColumn	ForeignKeyColumn	Source element of the DataItem must be of type ColumnBinding

The corresponding element in the Analysis Management Objects (AMO) object model is DataItem.

See Also

Reference

Analysis Services Scripting Language XML Data Types (ASSL)

Help and Information

Getting SQL Server 2005 Assistance