Measure Element (ASSL)

Defines a measure.

Syntax

<Measures>
   <Measure> <!-- ancestor: MeasureGroup -->
      <Name>...</Name>
      <ID>...</ID>
      <Description>...</Description>
      <AggregateFunction>...</AggregateFunction>
            <DataType>...</DataType>
            <Source>...</Source>
      <Visible>...</Visible>
      <MeasureExpression>...</MeasureExpression>
      <DisplayFolder>...</DisplayFolder>
      <FormatString>...</FormatString>
      <BackColor>...</BackColor>
      <ForeColor>...</ForeColor>
            <FontName>...</FontName>
            <FontSize>...</FontSize>
            <FontFlags>...</FontFlags>
            <Translations>...</Translations>
      <Annotations>...</Annotations>
   </Measure>
   <!-- or  -->
   <Measure xsi:type="AggregationInstanceMeasure">...</Measure> <!-- parent: AggregationInstance -->
      <!-- or  -->
   <Measure xsi:type="MeasureBinding">...</Measure> <!-- ancestor: MeasureGroupBinding (out-of-line) -->
   <!-- or  -->
   <Measure xsi:type="PerspectiveMeasure">...</Measure> <!-- ancestor: PerspectiveMeasureGroup -->
</Measures>

Element Characteristics

Characteristic	Description
Data type and length	Ancestor or ParentData Type AggregationInstanceAggregationInstanceMeasure MeasureGroupNone MeasureGroupBinding (out-of-line)MeasureBinding PerspectiveMeasureGroupPerspectiveMeasure
Default value	None
Cardinality	0-n: Optional element that can occur more than once.

Element Relationships

Relationship	Element
Parent elements	Measures
Child elements	Ancestor or ParentChild elements MeasureGroupAggregateFunction, Annotations, BackColor, DataType, Description, DisplayFolder, FontFlags, FontName, FontSize, ForeColor, FormatString, ID, MeasureExpression, Name, Source, Translations, Visible All othersNone

Remarks

Binding details can be provided for a measure. These details then act as the defaults per partition.

In larger cubes, there may be hundreds of measures and hierarchies. The DisplayFolder property defines user appearance on the client. The value of the DisplayFolder property can contain any one of the following options:

• Be empty, denoting that the measure does not belong to a folder.

• Contain a single folder name, denoting that the measure should be rendered as belonging to a folder with the same name.

• Contain multiple folder names separated by a backslash (\), denoting an embedded folder hierarchy.

The DisplayFolder property also applies to calculated measures and hierarchies.

The corresponding elements in the Analysis Management Objects (AMO) object model are Measure and PerspectiveMeasure.

See Also

Reference

Objects (ASSL)