MDAC 2.5 SDK - OLE DB Programmer's Reference
Chapter 24: Multidimensional Expressions
The SELECT list for the example dataset follows:
SELECT CROSSJOIN({Venkatrao, Netz},
{USA_North.CHILDREN, USA_South, Japan}) ON COLUMNS,
{Qtr1.CHILDREN, Qtr2, Qtr3, Qtr4.CHILDREN} ON ROWS
A SELECT list should not be specified where the axes are not contiguous. For instance, it is an error to have ROWS and PAGES, but not COLUMNS; or to have COLUMNS and PAGES, but not ROWS.
However, a SELECT list can be specified with no axes. It is not an error to have an empty SELECT list. In this case, all dimensions are slicer dimensions and the MDX statement selects at most one cell.