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.