Example 5

In this example, CrossJoin is used to request levels 1–2 for Market and Product.

SELECT NON EMPTY { [Profit] } ON COLUMNS,
NON EMPTY Crossjoin ([Market].Levels(2).AllMembers,[Product].Levels(2).ALLMEMBERS)
   DIMENSION PROPERTIES MEMBER_CAPTION 
ON ROWS 
FROM Sample.Basic

This query has the following result (truncated):

[Market]. Levels(1). [MEMBER_ CAPTION]	[Market]. Levels(2). [MEMBER_ CAPTION]	[Product]. [Family]. [MEMBER_ CAPTION]	[Product]. [SKU]. [MEMBER_ CAPTION]	[Profit]
East	New York	Colas	Cola	3498
East	New York	Root Beer	Old Fashioned	-2594
East	New York	Root Beer	Birch Beer	3086
East	New York	Cream Soda	Dark Cream	2496
East	New York	Cream Drinks	Vanilla Cream	-1952
East	New York	Fruit Soda	Grape	1329
East	New York	Fruit Soda	Orange	1388
East	New York	Fruit Soda	Strawberry	951
...	...	...	...	...