2.1.19 TMeasure

The TMeasure complex type is an extension of the TProperty type (section 2.1.14), adding components that appear only in measures.

The TMeasure complex type is defined in the schema as follows.

   <xs:complexType name ="TMeasure">
     <xs:complexContent>
       <xs:extension base="bi:TProperty">
         <xs:sequence>
           <xs:element name="Kpi" type ="bi:TKpi" minOccurs ="0" maxOccurs="1" />
           <xs:element name="FormatBy" type="bi:TPropertyRefs" minOccurs="0"
            maxOccurs="1"/>
           <xs:element name="ApplyCulture" type="bi:TPropertyRefs" minOccurs="0"
            maxOccurs="1"/>
           <xs:element name="ContainsDetailRows" type="xs:boolean" minOccurs="0"
            maxOccurs="1"/>
         </xs:sequence>
         <xs:attribute name="IsSimpleMeasure" type="xs:boolean" default="true"/>
         <xs:attribute name="ActualType" type="xs:string"/>
       </xs:extension>
     </xs:complexContent>
   </xs:complexType>

The element and attribute that are defined by the TMeasure complex type are specified in the following tables.

Element

Description

Kpi

In CSDLBI 1.1, CSDLBI 2.0, and CSDLBI 2.5, a key performance indicator (KPI). The contents of this element are defined by the TKpi complex type (section 2.1.20).

FormatBy

In CSDLBI 2.0 and CSDLBI 2.5, a reference to a measure within the entity that contains a format string for the current measure. It can be used to apply proper formatting to the values of the current measure.

ApplyCulture

In CSDLBI 2.0 and CSDLBI 2.5, a reference to a measure within the entity that contains a culture for each value of the current measure. It can be used to apply proper transformation on the values of current measure in order to display them properly.

ContainsDetailRows<7>

In CSDLBI 2.0 and CSDLBI 2.5, a Boolean value that indicates whether the measure contains a user-defined DetailRows expression, as specified in [MS-SSAS-T] section 2.2.5.28. A value of "true" means that a DetailRows expression is defined either on this measure or on the table that owns this measure and that the DetailRows expression does not refer to any restricted objects in the model.

Attribute

Description

IsSimpleMeasure

A Boolean value that indicates whether the formula that is used in the measure is one of the simple aggregations (Sum, Count, Min, Max, Avg, DistinctCount). The value "true" means that one of the simple aggregations is used. The actual value is derived from the IsSimpleMeasure element in the model, as specified in [MS-SSAS] section 2.2.4.2.2.10.2.

ActualType

In CSDLBI 2.0 and CSDLBI 2.5, a string value that, if present, contains "Any" as the only possible value, which indicates that the actual measure type could change for each value. If so, the Type attribute of the Property element (see [MC-CSDL] section 2.1.3) is only a suggestion of what default data type is to be used when the client attempts to visualize values.

Show: