|Q:How do you map MEASURE_AGGREGATOR field int value in the MDSCHEMA_MEASURES DMV to text representation?|
|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:
Sample query where this mapping is used: "How can I get a list of measures in one measure group from SSAS DMVs?"
- How to install Adventure Works SQL DW and Analysis Services 2005/2008 sample database and project
- MDX-How can I get Last (Previous) Year to Date (YTD) values?
- How to fix Analysis Services deployment error No mapping between account names and security IDs was done
- MDX-How do you calculate monthly average of one year, optionally including empty months?
- What TCP port SQL Server Analysis Services 2005 uses