| 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?"
|
Most read
- 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?
