Skip to main content
New features in Named Sets in Analysis Service 2008
Entry Date: Rate:
Site:
Keywords:
RSS Description:
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.
Comments:

Moving to SSAS 2008 is a good idea... one of the good things that it includes are dynamic named sets, ... when using sets on 2005 you could run in a problem like "Hey first time I run the set it returned the right data, now I'm querying with other dimensions and is not working properly" (that usually happens when you apply functions like ranking...