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.<95>

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.<96>

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.

  • Last updated on