FormatString Element (ASSL)

Describes the display format for a CalculationProperty element or a Measure element.

Syntax

<CalculationProperty> <!-- or Measure -->
   ...
   <FormatString>...</FormatString>
   ...
</CalculationProperty>

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 elements

CalculationProperty, Measure

Child elements

None

Remarks

The FormatString property contains a Multidimensional Expressions (MDX) expression. In the case of CalculationProperty elements, it applies to elements with a CalculationType of Member or Cells.

The elements that correspond to the parents of FormatString in the Analysis Management Objects (AMO) object model are CalculationProperty and Measure.

See Also

Reference

CalculationProperties Element (ASSL)
MdxScript Element (ASSL)
MdxScripts Element (ASSL)
Properties (ASSL)

Help and Information

Getting SQL Server 2005 Assistance