Example 1

The following query requests all members of level 1.

SELECT NON EMPTY {[Profit]} ON COLUMNS, 
NON EMPTY [Product].Levels(1).ALLMEMBERS ON ROWS 
FROM Sample.Basic

This query has the following result:

[Product].[Family].[MEMBER_CAPTION][Profit]
10030468
20027954
30025799
40021301
Diet28826