2
kudos
spam Kudos Remove

Static Named Sets v/s Dynamic Named Sets - Some Random Thoughts

published 611 days, 2 hours, 55 minutes ago posted by jacobsebastianjacobsebastian 620 days, 6 hours, 24 minutes ago
Sunday, June 06, 2010 11:19:29 AM GMT Friday, May 28, 2010 7:50:04 AM GMT

Many times, it can happen that we end up writing very complex MDX expressions revolving sets. To simplify such expressions or to improve the performance of some queries, we can extract the definitions of some sets into a separate named set expression which are called named sets. A named set can be created either using a CREATE SET statement or a WITH SET statement (For syntax, refer Building Named Sets in MDX). In SQL Server 2005, there was only the Static named sets feature but in SQL Server 2008, both Dynamic and Static named sets are present.

category: Warehousing | clicked: 1 | | source: beyondrelational.com | show counter code
tags: MDX, SSAS

No comments yet, be the first one to post comment.

To post your comment please login or signup