MeasureGroupMeasures (MDX)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Returns a set of measures that belongs to the specified measure group.

Syntax


MEASUREGROUPMEASURES(MeasureGroupName)  

Arguments

MeasureGroupName
A valid string expression that contains the name of the measure group from which to retrieve the set of measures.

Remarks

The specified string must match the measure group name exactly. Square brackets for measure group names with spaces are not required.

Example

The following example returns all of the measures in the Internet Sales measure group in the Adventure Works cube.

SELECT MeasureGroupMeasures('Internet Sales') ON 0  
FROM [Adventure Works]  

See Also

MDX Function Reference (MDX)