Listing 1: Code That Uses the Descendants and Children Functions

SELECT Descendants([Time].[1998],[Time].[Month]) ON COLUMNS,
	[Product].[AllProducts].[Drink].[Beverages].
	[Hot Beverages].Children ON ROWS
FROM Warehouse