|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?
- What TCP port SQL Server Analysis Services 2005 uses
- MDX-How do you calculate monthly average of one year, optionally including empty months?
- MDX-How do I calculate sales for 12 Month to date?