Q:How do you map MEASURE_AGGREGATOR field int value in the MDSCHEMA_MEASURES DMV to text representation?
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 |
| 1 | Sum |
| 2 | Count |
| 3 | Min |
| 4 | Max |
| 8 | DistinctCount |
| 9 | None |
| 10 | AverageOfChildren |
| 11 | FirstChild |
| 12 | LastChild |
| 13 | FirstNonEmpty |
| 14 | LastNonEmpty |
| 15 | ByAccount |
| 127 | Calculated measure |
Sample query where this mapping is used: "How can I get a list of measures in one measure group from SSAS DMVs?"