Skip to content

measure-element-assl.md

Latest commit

 

History

History
111 lines (92 loc) · 5.85 KB

measure-element-assl.md

File metadata and controls

111 lines (92 loc) · 5.85 KB
title Measure Element (ASSL) | Microsoft Docs
ms.custom
ms.date 03/06/2017
ms.prod sql-server-2016
ms.reviewer
ms.suite
ms.technology
analysis-services
docset-sql-devref
ms.tgt_pltfrm
ms.topic reference
apiname
Measure Element
apilocation
apitype Schema
applies_to
SQL Server 2016 Preview
f1_keywords
Measure
helpviewer_keywords
Measure element
ms.assetid 4c2c2ed1-7f78-4564-982a-132f13bea36f
caps.latest.revision 38
author Minewiskan
ms.author owend
manager erikre

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 See the table below.
Default value None
Cardinality 0-n: Optional element that can occur more than once.
Ancestor or Parent Data Type
AggregationInstance AggregationInstanceMeasure
MeasureGroup None
MeasureGroupBinding (out-of-line) MeasureBinding
PerspectiveMeasureGroup PerspectiveMeasure

Element Relationships

Relationship Element
Parent elements Measures
Child elements See the table below.
Ancestor or Parent Child elements
MeasureGroup AggregateFunction, Annotations, BackColor, DataType, Description, DisplayFolder, FontFlags, FontName, FontSize, ForeColor, FormatString, ID, MeasureExpression, Name, Source, Translations, Visible
All others None

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 xref:Microsoft.AnalysisServices.Measure and xref:Microsoft.AnalysisServices.PerspectiveMeasure.

See Also

Objects (ASSL)