2.2.4.2.2.11.3 Measure

This complex type represents a measure.

   <xsd:complexType name="Measure">
     <xsd:all>
       <xsd:element name="Name" type="xsd:string"/>
       <xsd:element name="ID" type="xsd:string" minOccurs="0"/>
       <xsd:element name="Description" type="xsd:string" minOccurs="0"/>
       <xsd:element name="AggregateFunction" minOccurs="0">
         <xsd:simpleType>
           <xsd:restriction base="xsd:string" >
             <xsd:enumeration value="Sum" />
             <xsd:enumeration value="Count" />
             <xsd:enumeration value="Min" />
             <xsd:enumeration value="Max" />
             <xsd:enumeration value="DistinctCount" />
             <xsd:enumeration value="None" />
             <xsd:enumeration value="ByAccount" />
             <xsd:enumeration value="AverageOfChildren" />
             <xsd:enumeration value="FirstChild" />
             <xsd:enumeration value="LastChild" />
             <xsd:enumeration value="FirstNonEmpty" />
             <xsd:enumeration value="LastNonEmpty" />
           </xsd:restriction>
         </xsd:simpleType>
       </xsd:element>
       <xsd:element name="DataType" minOccurs="0">
         <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="Variant" />
           </xsd:restriction>
         </xsd:simpleType>
       </xsd:element>
       <xsd:element name="Source" type="DataItem" />
       <xsd:element name="Visible" type="xsd:boolean" minOccurs="0"/>
       <xsd:element name="MeasureExpression" type="xsd:string" minOccurs="0"/>
       <xsd:element name="DisplayFolder" type="xsd:string" minOccurs="0"/>
       <xsd:element name="FormatString" type="xsd:string" minOccurs="0"/>
       <xsd:element name="BackColor" type="xsd:string" minOccurs="0"/>
       <xsd:element name="ForeColor" type="xsd:string" minOccurs="0"/>
       <xsd:element name="FontName" type="xsd:string" minOccurs="0"/>
       <xsd:element name="FontSize" type="xsd:string" minOccurs="0"/>
       <xsd:element name="FontFlags" type="xsd:string" minOccurs="0"/>
       <xsd:element name="Translations" minOccurs="0">
         <xsd:complexType>
           <xsd:sequence>
             <xsd:element name="Translation"  type="Translation" minOccurs="0"
                          maxOccurs="unbounded"/>
           </xsd:sequence>
         </xsd:complexType>
       </xsd:element>
       <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
Name		[Required]	The object name. The name of the measure MUST be unique within the Cube, not only within the MeasureGroup.
ID		Defaults to Name	The object ID string.
Description		Empty	The object description.
AggregateFunction		"Sum"	A string that specifies the type of aggregate function used by the measure.
DataType		Empty	The data type.
Source		[Required]	The source of the measure data. Type is DataItem. The Source element within the DataItem MUST be one of the following types: RowBinding, ColumnBinding, MeasureBinding, or CubeDimensionBinding.
Visible		True	When true, indicates to the client that the Measure is to be visible; otherwise, false.
MeasureExpression		Empty	Contains an MDX expression that specifies how the measure value is computed.
DisplayFolder		Empty	Defines the display folder for the measure.
FormatString		Empty	A string that specifies how to format measure values to produce a formatted value. For a description of the content of the string, see [MSDN-FSCMDX].
BackColor		Empty	Specifies the background color of a cell in the red-green-blue (RGB) format.<87> The valid range for an ordinary RGB color is from zero (&H00000000) to 16,777,215 (&H00FFFFFF). The high byte of a number in this range always equals zero. The lower 3 bytes, from least to most significant byte, determine the amount of red, green, and blue, respectively. The red, green, and blue components are each represented by a number between 0 and 255 (&HFF).
ForeColor		Empty	Specifies the foreground color of a cell in the RGB format.<88> The valid range for an ordinary RGB color is from zero (&H00000000) to 16,777,215 (&H00FFFFFF). The high byte of a number in this range always equals zero. The lower 3 bytes, from least to most significant byte, determine the amount of red, green, and blue, respectively. The red, green, and blue components are each represented by a number between 0 and 255 (&HFF).
FontName		Empty	The font to be used to display the value or formatted value of this measure.
FontSize		Empty	The font size to be used to display the value of formatted value of this measure.
FontFlags		Empty	A bitmask that details effects on the font. The value is the result of a bitwise OR operation of one or more of the following constants: BOLD = 1 ITALIC = 2 UNDERLINE = 4 STRIKEOUT = 8
Translations		Empty	A collection of Translation objects.
Annotations		Empty	A collection of Annotation objects.