TechNet
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

Measure Element (ASSL)

 

Applies To: SQL Server 2016 Preview

Defines a measure.

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

CharacteristicDescription
Data type and lengthSee the table below.
Default valueNone
Cardinality0-n: Optional element that can occur more than once.
Ancestor or ParentData Type
AggregationInstanceAggregationInstanceMeasure
MeasureGroupNone
MeasureGroupBinding (out-of-line)MeasureBinding
PerspectiveMeasureGroupPerspectiveMeasure
RelationshipElement
Parent elementsMeasures
Child elementsSee the table below.
Ancestor or ParentChild elements
MeasureGroupAggregateFunction, Annotations, BackColor, DataType, Description, DisplayFolder, FontFlags, FontName, FontSize, ForeColor, FormatString, ID, MeasureExpression, Name, Source, Translations, Visible
All othersNone

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.

Objects (ASSL)

Community Additions

ADD
Show:
© 2016 Microsoft