MDAC 2.5 SDK - OLE DB Programmer's Reference
Chapter 23: Rowsets in OLE DB for OLAP

DIMENSION PROPERTIES Example

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:

• It is assumed that the Products dimension has only one level.
  
  
• All names that are made of multiple components—that is, all column names and column values for the UNIQUE_NAME columns—are component-delimited. (Each component is delimited.)
  
  
• Although the CAPTION property was asked for on the COLUMNS axis, it was ignored, and column names consist of UNIQUE_NAME values.
  
  
• For an explanation of the NULL values in the first row, see "Appearance of NULLs in a Flattened Rowset."