SSAS Articles 
SSAS 2008 Dynamic Named Sets in SQL Server Analysis Service 2008
SSAS 2008 Dynamic Named Sets in SQL Server Analysis Service 2008
| Dynamic Named Sets in SQL Server Analysis Service 2008 |
| Written by Kasim Wirama |
| Sunday, 02 March 2008 17:54 |
|
One of improvement in area of Analysis Service 2008 is dynamic named sets feature in MDX (multi dimensional expression). DMX language is used by analysis service client to interact with Analysis Service Engine. There are several scope in named sets, i.e. : query scope, session scope (possibly several query in one session), or cube scope (the named sets is defined inside cube with MDX scripting). In previous version before SQL Server 2008, named sets is static now in SQL Server 2008, you have options whether to define the named set static or dynamic. Below sub section, I present problems on static named sets as reasons why dynamic named sets comes in handy. |
Latest Author Articles
All articles by Kasim WiramaTop 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
