To query multiple dimensions on a single axis:
On the column axis, specify two tuples, each of which is a member combination rather than a single member. Enclose each tuple in parentheses, because multiple members are represented in each tuple.
SELECT
{([100-10],[East]), ([100-20],[East])}
ON COLUMNS,
{}
ON ROWS
FROM Sample.Basic
On the row axis, specify four two-member tuples, nesting each Quarter with Profit:
SELECT {([100-10],[East]), ([100-20],[East])} ON COLUMNS, { ([Qtr1],[Profit]), ([Qtr2],[Profit]), ([Qtr3],[Profit]), ([Qtr4],[Profit]) } ON ROWS FROM Sample.Basic
Paste the query into the MaxL Shell and run it, as described in Exercise: Running Your First Query.
Results of the query are shown in Table 112: