Microsoft OLE DB 2.0 Programmers Reference and Data Access SDK (Microsoft Professional Editions)
| OLE DB Programmer's Reference |
Consider the following query:
SELECT CROSSJOIN ({Access, Word}, {Kansas, Buffalo, Topeka, USA, Canada}) ON COLUMNS, {[1994].Qtr1.MEMBERS, [1994].Qtr2, [1994].Qtr3, [1994].Qtr4.MEMBERS} ON ROWS FROM SalesCube WHERE (Sales)
For a detailed analysis of this example, see the following topics in this section:
- COLUMNS Axis Expression
- ROWS Axis Expression
- Getting Cell Values
1998-2001 Microsoft Corporation. All rights reserved.