Export (0) Print
Expand All
Avg
IIf
Lag
Max
Min
Mtd
Qtd
Sum
Var
Wtd
Ytd
Expand Minimize
1 out of 2 rated this helpful - Rate this topic

ValidMeasure (MDX)

Updated: 17 July 2006

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.


ValidMeasure(Tuple_Expression) 
Tuple_Expression

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

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.

Release History

17 July 2006

Changed content:
  • Updated syntax and arguments to improve clarity.
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.