SSAS Articles 
SSAS 2008 Dynamic Named Sets in Analysis Service 2008
SSAS 2008 Dynamic Named Sets in Analysis Service 2008
| Dynamic Named Sets in Analysis Service 2008 |
| Written by Amish Manubhai Shah |
| Tuesday, 17 June 2008 17:18 |
|
One of the important feature in SQL Server 2008 is Dynamic Named Sets. Till SQL Server 2005 named sets were static. In SQL Server 2005 once named sets are executed they were remain static during whole session or query or cube. This was giving wrong results during Topcount or Bottomcount like functions. Lets look at the example to get more details |
Latest Author Articles
All articles by Amish Manubhai ShahTop 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
