Export (0) Print
Expand All

Measure Class

Represents a measure within a cube or measure group.

Object
  Microsoft.AnalysisServices.AdomdClient.Measure

Namespace:  Microsoft.AnalysisServices.AdomdClient
Assembly:  Microsoft.AnalysisServices.AdomdClient (in Microsoft.AnalysisServices.AdomdClient.dll)

public sealed class Measure

The Measure type exposes the following members.

  NameDescription
Public propertyCaptionGets the caption of the Measure.
Public propertyDescriptionGets the description of the Measure.
Public propertyDisplayFolderThis member is reserved for future use.
Public propertyExpressionGets the Multidimensional Expressions (MDX) expression that is used to aggregate the Measure.
Public propertyNameGets the name of the Measure.
Public propertyNumericPrecisionGets the numeric precision value for the Measure.
Public propertyNumericScaleGets the numeric scale for the Measure.
Public propertyParentCubeGets a CubeDef that contains the Measure.
Public propertyPropertiesGets an AdomdPropertyCollection that contains the properties associated with the Measure.
Public propertyUniqueNameGets the unique name of the Measure.
Public propertyUnitsGets a description of the unit of measure for the Measure.
Top

  NameDescription
Public methodEqualsDetermines whether two instances of Measure are equal. (Overrides ObjectEquals(Object).)
Public methodGetHashCodeServes as a hash function for a particular type, suitable for use in hashing algorithms and data structures such as hash tables. (Overrides ObjectGetHashCode.)
Public methodGetType (Inherited from Object.)
Public methodToStringReturns a String that represents the current instance of the Measure. (Overrides ObjectToString.)
Top

  NameDescription
Public operatorStatic memberEqualityDetermines whether two instances of Measure are equal.
Public operatorStatic memberInequalityDetermines whether two instances of Measure are unequal.
Top

A measure represents the data within a fact table that is being organized and aggregated by the cube.

In ADOMD.NET, the Measure represents the metadata for a measure within a cube. A measure is not explicitly identified in a cellset, because a measure is treated as a member for querying purposes and is represented by a Measure within the Measures collection of a CubeDef.

The following subroutine, given a CubeDef, iterates through the Measures collection and displays information for each Measure:

Public Sub ListMeasures(ByRef CubeToCheck As CubeDef)

    ' Check the parameter before performing actions on it.
    If CubeToCheck Is Nothing Then
        Throw New System.ArgumentNullException("CubeToCheck")
    Else
        ' Iterate through the Measures collection of the
        ' CubeDef object.

        Try
            Dim measureToCheck As Measure

            Debug.WriteLine("Found " & CubeToCheck.Measures.Count & _
                " measure(s) in cube:")

            For Each measureToCheck In CubeToCheck.Measures
                Debug.WriteLine("Measure:  " & measureToCheck.Name)
                Debug.WriteLine("  Caption:        " & _
                    measureToCheck.Caption)
                Debug.WriteLine("  Description:    " & _
                    measureToCheck.Description)

            Next
        Catch ex As AdomdConnectionException
            ' The connection could not be opened or was disconnected.
            ' This error can occur at any time, if the provider is 
            ' disconnected from the server.
            Debug.WriteLine(ex)
            Throw ex
        Catch ex As AdomdErrorResponseException
            ' A response is received from a provider which indicates an error.
            Debug.WriteLine(ex)
            Throw ex
        Catch ex As AdomdUnknownResponseException
            ' A response has been returned from the provider that 
            ' was not understood.
            Debug.WriteLine(ex)
            Throw ex
        Catch ex As AdomdCacheExpiredException
            ' A cached version of an ADOMD.NET object is no longer valid.
            ' This error is typically raised when reviewing metadata.
            Debug.WriteLine(ex)
            Throw ex
        Catch ex As AdomdException
            ' Any other error raised by ADOMD.NET.
            Debug.WriteLine(ex)
            Throw ex
        Catch ex As Exception
            ' Any other error.
            Debug.WriteLine(ex)
            Throw ex
        End Try
    End If
End Sub

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Community Additions

ADD
Show:
© 2014 Microsoft