O'Reilly logo

Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008 by Kevin S. Goff Lynn Langit Davide Mauri, Sahil Malik, and John C. Welch

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

About Named Sets

We introduced named sets back in Chapter 10. Named sets are a collection of tuples (often an ordered collection) from one or more dimensions. So, as a reminder example, you can build a list of the top 10 products by profit, use a Rank function to generate a ranking number for each product, and then display the Internet Gross Profit and rank number for each product, for sales in Canada (as shown in the next code sample and Figure 11-11).

Basic top-10 list generated when using TopCount and Rank in-line

Figure 11-11. Basic top-10 list generated when using TopCount and Rank in-line

WITH SET [Top10ProductsByProfit] AS TopCount( [Product].[Product Categories].[Product].Members, 10,[Measures].[Internet ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required