• Run this on AdventureWorks cube.

    Example of Product hierarchy.

    I think it is what you are describing.

    Basically show all members and showing no measure.

    SELECT { } ON COLUMNS, { ([Product].[Product Model Lines].[Model].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM [Adventure Works] CELL PROPERTIES VALUE