The Members function can be used to return all members of a specified generation or level. Its syntax when used with a layer argument:
where the layer argument you provide indicates the generation or level of members you want returned.
To use the Members function:
Use the Members function and the Levels function to select all level 0 members in the Market dimension of Sample.Basic:
SELECT
Members(Market.levels(0))
ON COLUMNS
FROM Sample.Basic
Paste the query into the MaxL Shell and run it, as described in Exercise: Running Your First Query.