MDAC 2.5 SDK - OLE DB Programmer's Reference
Chapter 26: Mapping MDX to SQL Statements

Mapping Example

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