This topic has not yet been rated - Rate this topic

Measure Element (ASSL)

SQL Server 2005

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>

Element Characteristics

Characteristic

Description

Data type and length

AggregationInstance AggregationInstanceMeasure

MeasureGroup None

MeasureGroupBinding (out-of-line) MeasureBinding

PerspectiveMeasureGroup PerspectiveMeasure

Ancestor or Parent	Data Type

Default value

None

Cardinality

0-n: Optional element that can occur more than once.

Element Relationships

Relationship

Element

Parent elements

Measures

Child elements

MeasureGroup AggregateFunction, Annotations, BackColor, DataType, Description, DisplayFolder, FontFlags, FontName, FontSize, ForeColor, FormatString, ID, MeasureExpression, Name, Source, Translations, Visible

All others None

Ancestor or Parent	Child elements

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.

Reference

Objects (ASSL)

Help and Information

Getting SQL Server 2005 Assistance

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD