August MDX Puzzle Solution Revealed - 11 Aug 2000

Suppose you're developing an application that must provide users access to large amounts of information and you decide the best method is to display the data one page at a time (a page is 50 rows). If a user asks for unit sales to each customer during the four quarters of 1997, how would you write the query to return the first page of data? Remember, you want to return the customers in the order that they appear in the sales cube.

select [1997].Children on columns,  Subset( [Customers].[Name].Members, 0, 50 ) on rowsfrom Saleswhere ([Unit Sales])

This query uses the Subset function to return the first 50 customers on the rows.