Example Using DIMENSION PROPERTIES

Consider the 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 results in the following flattened rowset:

[Sales- rep]. [Phone Num- ber]	[Sales- rep]. [MEM- BER_ CAP- TION]	[Sales- rep]. [MEM- BER_ UNIQUE_ NAME]	[Pro- ducts]. [SKU]	[Prod- ucts]. [MEM- BER_ CAP- TION]	[Pro- ducts]. [MEM- BER_ UNIQUE_ NAME]	[Meas- ures]. [Cost]	[Meas- ures]. [Sales]
555-1212	Venka-trao	[Sales-rep]. [Venka-trao]	125678	Microsoft Excel	[Products]. [Microsoft Excel]	345678	NULL
555-1212	Venka-trao	[Sales-rep]. [Venka-trao]	135742	Microsoft Word	[Products]. [Microsoft Word]	823456	789101
555-1214	Netz	[Sales-rep]. [Netz]	125678	Microsoft Excel	[Products]. [Microsoft Excel]	346587	678432
555-1214	Netz	[Sales-rep]. [Netz]	135742	Microsoft Word	[Products]. [Microsoft Word]	932456	732489

It is important to note the following things:

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 “Nulls.”