OLE DB Programmer's Reference |
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 example, 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.
1998-2001 Microsoft Corporation. All rights reserved.