Example MDX Query

Combining the SELECT clause with the FROM and WHERE clauses, the query for the example dataset shown in Cube and Dataset Example is:

SELECT CROSSJOIN({Smith, Jones},

   {USA_North.CHILDREN, USA_South, Japan}) ON COLUMNS,

   {Qtr1.CHILDREN, Qtr2, Qtr3, Qtr4.CHILDREN} ON ROWS

FROM SalesCube

WHERE (Sales, [1997], Products.All)


Note For simplicity, this example does not use qualified member names. In practice, use qualified member names whenever necessary to avoid ambiguity.


(c) 1988-1998 Microsoft Corporation. All Rights Reserved.