SSAS 2008 SSAS 2008: Whats new in the Schema Rowsets?
| SSAS 2008: Whats new in the Schema Rowsets? |
| Written by Darren Gosbell |
| Wednesday, 20 February 2008 20:30 |
|
I was asking myself this question recently and while I could not find anything in Books Online, it is not too hard to figure this out for ourselves. The following comparison was run between SSAS 2005 SP2 and the February CTP (CTP6) of SSAS 2008. I really love the way that you can discover the metadata in SSAS, all I had to do is to run a DISCOVER_SCHEMA_ROWSETS XML/A command against each server and then use XMLNotepad 2007 to compare the resulting XML. In the SQL Server 2008 you should find that features are not included in a CTP until they are pretty much complete, including documentation. So you can find documentation for all of this stuff under the "Schema Rowsets" section in Books Online (BOL) here: http://msdn2.microsoft.com/en-us/library/ms126233(SQL.100).aspx. In fact I have used a number of snippets from BOL in the rest of this post. |
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
