I am trying to access the member properties. Although the query (below) returns a result set, the member property Product Name requested does not show in the result set. Any Ideas?
SELECT NON EMPTY [Product].[product code].MEMBERS
DIMENSION PROPERTIES [Product].[product code].[product name]
ON rows,
{measures.measureslevel.members} on columns
FROM Sales
WHERE ([2001])
SELECT NON EMPTY [Product].[product code].MEMBERS
DIMENSION PROPERTIES [Product].[product code].[product name]
ON rows,
{measures.measureslevel.members} on columns
FROM Sales
WHERE ([2001])