MDAC 2.5 SDK - OLE DB Programmer's Reference
Chapter 24: Multidimensional Expressions

SalesData Example Dataset Expression

Combining the SELECT list with the FROM and WHERE clauses, the query for the example dataset, SalesData, 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])