Combining the SELECT clause with the FROM and WHERE clauses, the query 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
FROM SalesCube
WHERE (Sales, [1997], Products.All)
Note For simplicity, this example does not use qualified member names. In practice, use qualified member names whenever necessary to avoid ambiguity.