Mapping Example

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.