2.2.4.2.2.19 DataItem

This complex type represents a scalar data item associated with an object, such as DimensionAttribute and Measure.

The Source element of the DataItem is of type Binding. However, in a specific instance of the DataItem, there are often additional constraints as to what type of Binding will be permitted, depending upon the parent of the DataItem. Within the tables throughout this document, it is noted exactly which derived types of Binding are permitted in each context and MUST be used for that particular context.

            
   <xsd:complexType name="DataItem">
     <xsd:all>
       <xsd:element name="DataType">
         <xsd:simpleType>
           <xsd:restriction base="xsd:string" >
             <xsd:enumeration value="WChar" />
             <xsd:enumeration value="Integer" />
             <xsd:enumeration value="BigInt" />
             <xsd:enumeration value="Single" />
             <xsd:enumeration value="Double" />
             <xsd:enumeration value="Date" />
             <xsd:enumeration value="Currency" />
             <xsd:enumeration value="UnsignedTinyInt" />
             <xsd:enumeration value="UnsignedSmallInt" />
             <xsd:enumeration value="UnsignedInt" />
             <xsd:enumeration value="UnsignedBigInt" />
             <xsd:enumeration value="Bool" />
             <xsd:enumeration value="Smallint" />
             <xsd:enumeration value="Tinyint" />
             <xsd:enumeration value="Binary" />
           </xsd:restriction>
         </xsd:simpleType>
       </xsd:element>
       <xsd:element name="DataSize" type="xsd:integer" minOccurs="0"/>
       <xsd:element name="MimeType" type="xsd:string" minOccurs="0"/>
       <xsd:element name="NullProcessing" minOccurs="0">
         <xsd:simpleType>
           <xsd:restriction base="xsd:string" >
             <xsd:enumeration value="Preserve" />
             <xsd:enumeration value="Error" />
             <xsd:enumeration value="UnknownMember" />
             <xsd:enumeration value="ZeroOrBlank" />
             <xsd:enumeration value="Automatic" />
           </xsd:restriction>
         </xsd:simpleType>
       </xsd:element>
       <xsd:element name="Trimming" minOccurs="0">
         <xsd:simpleType>
           <xsd:restriction base="xsd:string" >
             <xsd:enumeration value="Left" />
             <xsd:enumeration value="Right" />
             <xsd:enumeration value="LeftRight" />
             <xsd:enumeration value="None" />
           </xsd:restriction>
         </xsd:simpleType>
       </xsd:element>
       <xsd:element name="InvalidXmlCharacters"  minOccurs="0">
         <xsd:simpleType>
           <xsd:restriction base="xsd:string" >
             <xsd:enumeration value="Preserve" />
             <xsd:enumeration value="Remove" />
             <xsd:enumeration value="Replace" />
           </xsd:restriction>
         </xsd:simpleType>
       </xsd:element>
       <xsd:element name="Collation" type="xsd:string" minOccurs="0"/>
       <xsd:element name="Format" minOccurs="0">
         <xsd:simpleType>
           <xsd:restriction base="xsd:string" >
             <xsd:enumeration value="TrimRight" />
             <xsd:enumeration value="TrimLeft" />
             <xsd:enumeration value="TrimAll" />
             <xsd:enumeration value="TrimNone" />
           </xsd:restriction>
         </xsd:simpleType>
       </xsd:element>
       <xsd:element name="Source" type="Binding" minOccurs="0"/>
       <xsd:element name="Annotations" minOccurs="0">
         <xsd:complexType>
           <xsd:sequence>
             <xsd:element name="Annotation"  type="Annotation"
                          minOccurs="0" maxOccurs="unbounded"/>
           </xsd:sequence>
         </xsd:complexType>
       </xsd:element>
     </xsd:all>
   </xsd:complexType>

Element

Read-Only

Default value

Description

DataType

[Required]

The data type of the column.

DataSize

0

The data size in bytes. Zero means that the server will determine the DataSize.

MimeType

Empty

The MIME type. Applicable only if the DataType is Binary.

NullProcessing

"Automatic"

Sets the processing of NULL values:

  • "Automatic" – The server determines how null processing is handled.<110> "Automatic" uses the default processing that is appropriate for the element:

  • "UnknownMember" – Generates an unknown member. This value MUST NOT be used if the column is associated with a measure.

  • "ZeroOrBlank" – Converts the null value to zero (for numeric data items) or a blank string (for string data items).

  • "Preserve" – Preserves the null value.

  • "Error" – Raises an error. Value "Error" is not supported for measures. This value MUST NOT be used if the column is associated with a measure.

Trimming

"Right"

Specifies how data from the data source is trimmed. Applicable only to string data items.

InvalidXmlCharacters

"Preserve"

Specifies handling for invalid XML characters. The valid values are the following:

  • "Preserve" - Specifies that invalid XML characters are preserved in the character stream.

  • "Remove" – Specifies that invalid XML characters are removed.

  • "Replace" – Specifies that invalid XML characters are replaced with a question mark (?) character.

Collation

Empty

The collation of the data item. Applicable only to string data items.

Format

Empty

The format of the data item. The valid values are the following:

  • "TrimRight": The value is trimmed on the right.

  • "TrimLeft": The value is trimmed on the left.

  • "TrimAll": The value is trimmed on the left and the right.

  • "TrimNone": The value is not trimmed.

Source

Empty

The source of the data item. Which derived type of Binding is permitted is dependent upon the enclosing object, and is explained in the table for each enclosing object.

Annotations

Empty

A collection of Annotation objects.