3.1.4.2.2.1.3.9.1 Columns

  • Article

The MDSCHEMA_MEASURES rowset contains the following columns.

Name

Type

Restriction

Description

CATALOG_NAME

xsd:string

Yes

The name of the catalog to which this measure belongs.

SCHEMA_NAME

xsd:string

Yes

The name of the schema to which this measure belongs.<235>

CUBE_NAME

xsd:string

Yes

The name of the cube to which this measure belongs.

MEASURE_NAME

xsd:string

Yes

The name of the measure.

MEASURE_UNIQUE_NAME

xsd:string

Yes

The unique name of the measure.

MEASURE_CAPTION

xsd:string

A caption associated with the measure.

MEASURE_GUID

uuid

The GUID of the measure.

MEASURE_AGGREGATOR

xsd:int

An enumeration that identifies how a measure was derived. This enumeration can be one of the following values:

  • 1 – (MDMEASURE_AGGR_SUM) MEASURE aggregates from SUM.

  • 2 - (MDMEASURE_AGGR_COUNT) MEASURE aggregates from COUNT.

  • 3 - (MDMEASURE_AGGR_MIN) MEASURE aggregates from MIN.

  • 4 - (MDMEASURE_AGGR_MAX) MEASURE aggregates from MAX.

  • 5 - (MDMEASURE_AGGR_AVG) MEASURE aggregates from AVG.

  • 6 - (MDMEASURE_AGGR_VAR) MEASURE aggregates from VAR.

  • 7 - (MDMEASURE_AGGR_STD) Identifies that the measure aggregates from STDEV.

  • 8 - (MDMEASURE_AGGR_DST) Distinct Count: The aggregation is a count of unique members.

  • 9 - (MDMEASURE_AGGR_NONE) None: No aggregation is applied.

  • 10 - (MDMEASURE_AGGR_AVGCHILDREN) Average of Children: The aggregation of a member is the average of its children.

  • 11 - (MDMEASURE_AGGR_FIRSTCHILD) First Child: The member value is evaluated as the value of its first child along the time dimension.

  • 12 - (MDMEASURE_AGGR_LASTCHILD) Last Child: The member value is evaluated as the value of its last child along the time dimension.

  • 13 - (MDMEASURE_AGGR_FIRSTNONEMPTY) First Non-Empty: The member value is evaluated as the value of its first child along the time dimension that contains data.

  • 14 - (MDMEASURE_AGGR_LASTNONEMPTY) Last Non-Empty: The member value is evaluated as the value of its last child along the time dimension that contains data.

  • 15 - (MDMEASURE_AGGR_BYACCOUNT) ByAccount: The system uses the semiadditive behavior specified for the account type.

  • 127 - (MDMEASURE_AGGR_CALCULATED) Identifies that the measure was derived from a formula that was not any of the single functions listed in any of the preceding single functions.

  • 0 - (MDMEASURE_AGGR_UNKNOWN) Identifies that the measure was derived from an unknown aggregation function or formula.

DATA_TYPE

xsd:unsignedShort

This enumeration is the same as LEVEL_DBTYPE for MDSCHEMA_LEVELS. (See section 3.1.4.2.2.1.3.8.)

NUMERIC_PRECISION

xsd:unsignedShort

The maximum precision of the measure if the measure object's data type is Numeric, Decimal, or DateTime. NULL for all other property types.

NUMERIC_SCALE

xsd:short

The number of digits to the right of the decimal point if the measure object's type indicator is Numeric, Decimal or DateTime. Otherwise, this value is NULL.<236>

MEASURE_UNITS

xsd:string

The units for the measure.

DESCRIPTION

xsd:string

A description of the measure.

EXPRESSION

xsd:string

An expression for the member.

MEASURE_IS_VISIBLE

xsd:boolean

When true, indicates that the measure is visible. Always returns a value of true. If the measure is not visible, it will not be included in the schema rowset.

LEVELS_LIST

xsd:string

Not currently in use.

MEASURE_NAME_SQL_COLUMN_NAME

xsd:string

The name of the column in the SQL query that corresponds to the measure's name.

MEASURE_UNQUALIFIED_CAPTION

xsd:string

The caption of the measure, not qualified with the measure group caption.

MEASUREGROUP_NAME

xsd:string

Yes

The name of the measure group to which the measure belongs.

MEASURE_DISPLAY_FOLDER

xsd:string

The display folder of the measure.<237>

DEFAULT_FORMAT_STRING

xsd:string

The default format string for the measure.

The response has the following definition.

       <xsd:element name="root">
         <xsd:complexType>
           <xsd:sequence minOccurs="0" maxOccurs="unbounded">
             <xsd:element name="row" type="row" />
           </xsd:sequence>
         </xsd:complexType>
       </xsd:element>
       <xsd:simpleType name="uuid">
         <xsd:restriction base="xsd:string">
           <xsd:pattern value="[0-9a-zA-Z]{8}-[0-9a-zA-Z]{4}-[0-9a-zA-Z]{4}-
                               [0-9a-zA-Z]{4}-[0-9a-zA-Z]{12}" />
         </xsd:restriction>
       </xsd:simpleType>
       <xsd:complexType name="row">
         <xsd:sequence>
           <xsd:element sql:field="CATALOG_NAME" name="CATALOG_NAME" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="SCHEMA_NAME" name="SCHEMA_NAME" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="CUBE_NAME" name="CUBE_NAME" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="MEASURE_NAME" name="MEASURE_NAME" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="MEASURE_UNIQUE_NAME" name="MEASURE_UNIQUE_NAME" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="MEASURE_CAPTION" name="MEASURE_CAPTION" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="MEASURE_GUID" name="MEASURE_GUID" 
                            type="uuid" minOccurs="0" />
           <xsd:element sql:field="MEASURE_AGGREGATOR" name="MEASURE_AGGREGATOR" 
                            type="xsd:int" minOccurs="0" />
           <xsd:element sql:field="DATA_TYPE" name="DATA_TYPE" 
                            type="xsd:unsignedShort" minOccurs="0" />
           <xsd:element sql:field="NUMERIC_PRECISION" name="NUMERIC_PRECISION" 
                            type="xsd:unsignedShort" minOccurs="0" />
           <xsd:element sql:field="NUMERIC_SCALE" name="NUMERIC_SCALE" 
                            type="xsd:short" minOccurs="0" />
           <xsd:element sql:field="MEASURE_UNITS" name="MEASURE_UNITS" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="DESCRIPTION" name="DESCRIPTION" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="EXPRESSION" name="EXPRESSION" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="MEASURE_IS_VISIBLE" name="MEASURE_IS_VISIBLE" 
                            type="xsd:boolean" minOccurs="0" />
           <xsd:element sql:field="LEVELS_LIST" name="LEVELS_LIST" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="MEASURE_NAME_SQL_COLUMN_NAME"      
                            name="MEASURE_NAME_SQL_COLUMN_NAME" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="MEASURE_UNQUALIFIED_CAPTION"
                            name="MEASURE_UNQUALIFIED_CAPTION" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="MEASUREGROUP_NAME" name="MEASUREGROUP_NAME" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="MEASURE_DISPLAY_FOLDER" name="MEASURE_DISPLAY_FOLDER" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="DEFAULT_FORMAT_STRING" name="DEFAULT_FORMAT_STRING" 
                            type="xsd:string" minOccurs="0" />
         </xsd:sequence>
       </xsd:complexType>