Export (0) Print
Expand All

2.1.17 TMeasure

The TMeasure complex type is an extension of the TProperty type (section 2.1.13), 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: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 and CSDLBI 2.0, a key performance indicator (KPI). The contents of this element are defined by the TKpi complex type (section 2.1.18).

FormatBy

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

ApplyCulture

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

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, 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 SHOULD be used when the client attempts to visualize values.

Show:
© 2014 Microsoft