Format Element (ASSL)

APPLIES TO:yesSQL Server Analysis ServicesnoAzure Analysis Services

Contains the required format of the DataItem element.



Element Characteristics

Characteristic Description
Data type and length String
Default value None
Cardinality 0-1: Optional element that can occur once and only once.

Element Relationships

Relationship Element
Parent element DataItem
Child elements None


Allowed values for the Format element are Microsoft Office Excel formats, and the strings TrimRight, TrimLeft, TrimAll, and TrimNone. For trimming, TrimRight is the default.

The value of this element is limited to one of the strings in the following table.

Value Description
Any Excel format string Data is formatted according to the specified named or custom format string. Any format string that Excel supports can be supplied.
TrimAll Data is trimmed on the left and right.
TrimLeft Data is trimmed on the left.
TrimNone Data is not trimmed.
TrimRight Data is trimmed on the right.

The element that corresponds to the parent of Format in the Analysis Management Objects (AMO) object model is DataItem.

See Also

Properties (ASSL)