SSAS Articles 
SSAS 2008 SQL Server 2008 and Analysis Services DMV's
SSAS 2008 SQL Server 2008 and Analysis Services DMV's
| SQL Server 2008 and Analysis Services DMV's |
| Written by Jamie Mac |
| Saturday, 29 September 2007 17:25 |
|
One of the cool new features coming in SQL Server 2008 Analysis Services are Dynamic Management Views (DMV). Actually I never thought of them as DMVs coming from my background, but since everyone else calls them that, there's no reason we shouldn't either. So what are they and how did they come about? DMX users are most likely familiar with the syntax: SELECT * FROM MyDataMiningModel.CONTENT What you may not know is that this is really a DMX query against the MINING_CONTENT schema rowset - we simply exposed via the SQL-like syntax of DMX for convenience, placing a schema restriction on the model name. |
Top Rated
- SSAS Implementation Best Practices slides in PDF format
- SSRS Report Against a SSAS Parent Hierarchy
- Handling inter-dimensional members dependency and reducing cube sparsity using reference dimensions in Analysis Services 2005
- Cube structure optimization for MDX query performance in Analysis Services 2005 SP2: Tips for Parent Child Hierarchies usage
- Handling Multiple Calendars with a M2M Scenario
- Passing MDX parameters in Reporting Services reports
- Using UserName to Control Data Access and Default Member in SSAS 2K5 (Carrie Williams)
- SSAS Tutorial: SQL Server 2005 Analysis Services Tutorial by Accelebrate
