Exercise: Querying Multiple Dimensions on a Single Axis

  To query multiple dimensions on a single axis:

  1. Open qry_blank_2ax.txt.

  2. 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
  3. 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
  4. Save the query as qry_1ax.txt.

  5. 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:

Table 112. Results: Querying Multiple Dimensions on a Single Axis

  

100-10

100-20

  

East

East

Qtr1

Profit

2461

212

Qtr2

Profit

2490

303

Qtr3

Profit

3298

312

Qtr4

Profit

2430

287