The SELECT Clause

The SELECT clause for the example dataset shown in Cube and Dataset Example is:

SELECT CROSSJOIN({Smith, Jones},

{USA_North.CHILDREN, USA_South, Japan}) ON COLUMNS,

{Qtr1.CHILDREN, Qtr2, Qtr3, Qtr4.CHILDREN} ON ROWS