Example 7

The following example uses multiple, nested CrossJoins.

SELECT NON EMPTY { [Profit] } ON COLUMNS,
NON EMPTY {CROSSJOIN
                    ( 
                      CROSSJOIN( [Market].Levels(1).ALLMEMBERS, 
                                 [Product].[Family].ALLMEMBERS
                                ),
                      [Year].Levels(1).ALLMEMBERS
                     ) 
           } DIMENSION PROPERTIES MEMBER_CAPTION 
ON ROWS FROM Sample.Basic

This query has the following result (truncated):

[Market]. Levels(1). [MEMBER_ CAPTION]	[Product]. [Family]. [MEMBER_ CAPTION]	[Year]. Levels(1). [MEMBER_ CAPTION]	[Profit]
East	Colas	Qtr1	2747
East	Colas	Qtr2	3352
East	Colas	Qtr3	3740
East	Colas	Qtr4	2817
East	Root Beer	Qtr1	562
East	Root Beer	Qtr2	610
East	Root Beer	Qtr3	372
East	Root Beer	Qtr4	990
...	...	...	...