The SELECT List

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

Noncontiguous Axes in the SELECT List

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.



Microsoft Ole Db 2.0 Programmer's Reference and Data Access SDK
Microsoft OLE DB 2.0 Programmers Reference and Data Access SDK (Microsoft Professional Editions)
ISBN: 0735605904
EAN: 2147483647
Year: 1998
Pages: 1083

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net