例5

この例では、CrossJoinを使用して市場および製品のレベル1-2を要求しています。

      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

このクエリーには、次の結果があります(抜粋):

[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
...	...	...	...	...