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 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. |