OLE DB Programmer's Reference |
Consider the following MDX statement:
SELECT {Measures.Cost, Measures.Sales} DIMENSION PROPERTIES MEMBER_CAPTION ON COLUMNS, CROSSJOIN({Venkatrao, Netz}, Products.MEMBERS) DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME, SalesRep.[Phone Number], Products.SKU ON ROWS FROM Sales WHERE ([1991], Qtr1, USA)
This statement results in the following flattened rowset:
It is important to note the following:
1998-2001 Microsoft Corporation. All rights reserved.