Q:How do you map MEASURE_AGGREGATOR field int value in the MDSCHEMA_MEASURES DMV to text representation?
User Rating: / 2
PoorBest 
Written by Vidas Matelis   
Monday, 26 January 2009 02:21

Q: How do you map MEASURE_AGGREGATOR field int value in the MDSCHEMA_MEASURES DMV to text representation?

A: Here is a table that you can use for static mapping:

MEASURE_AGGREGATOR

Aggregation Function

1Sum
2Count
3Min
4Max
8DistinctCount
9None
10AverageOfChildren
11FirstChild
12LastChild
13FirstNonEmpty
14LastNonEmpty
15ByAccount
127Calculated measure

Sample query where this mapping is used: "How can I get a list of measures in one measure group from SSAS DMVs?"

 

 

Tags: 2008, dmv, faq
 

XL Cubed