ValidMeasure (MDX)

Returns the value of a measure in a cube by forcing inapplicable dimensions to their All level (or default member if not aggregatable) when returning the result for a specified tuple.

Syntax

ValidMeasure(Tuple_Expression) 

Arguments

  • Tuple_Expression
    A valid Multidimensional Expressions (MDX) expression that returns a tuple.

Remarks

The ValidMeasure function returns the measure value from the cell at the (All) level coordinates (or default member if not aggregatable) for the dimensions that are not common. In Microsoft SQL Server 2005 Analysis Services, the behavior specified by this function is the default server-side behavior and is controlled by the IgnoreUnrelatedDimensions property on the measure group object.

For each attribute in the specified tuple with granularity (not on the All member), the current coordinate for each such attribute is moved as follows:

  • Related attributes to the specified attribute member are moved to the member that exists with the current member.
  • Relating attributes to the specified attribute member are moved to the All member (or default member if not aggregatable).
  • Unrelated attributes are moved to the All member (based on measure).

For example, the granularity on a Time dimension is month. If you use the ValidMeasure function on cells in this Time dimension, cells at the week level will return the value at their month.

The following table illustrates the behavior of the ValidMeasure function.

Tuple No Time dimension Time dimension with granularity specified as at the Year level

Time.Jan

Returns Null - Coordinate of measure group’s scope.

Returns Null - Below granularity.

ValidMeasure(Time.Jan)

Returns data - ValidMeasure function forces Time to All level (or default member if not aggregatable).

Returns Null - Below granularity where ValidMeasure has no affect.

Time.[1997].<calculated member>

Returns Null - Coordinate of measure group’s scope.

Returns Null - Below granularity where ValidMeasure has no affect.

See Also

Reference

MDX Function Reference (MDX)

Help and Information

Getting SQL Server 2005 Assistance

Change History

Release History

17 July 2006

Changed content:
  • Updated syntax and arguments to improve clarity.