Example Dataset Expression

Combining the SELECT list with the FROM and WHERE clauses, the query for the example dataset is as follows:

SELECT CROSSJOIN({Venkatrao, Netz},
   {USA_North.CHILDREN, USA_South, Japan}) ON COLUMNS,
   {Qtr1.CHILDREN, Qtr2, Qtr3, Qtr4.CHILDREN} ON ROWS
FROM SalesCube
WHERE (Sales, [1991], Products.All)