Exercise: Limiting the Results with a Slicer Axis

  To use the slicer axis to limit results:

  1. Open gry_crossjoin_func.txt.

  2. Paste the query into the MaxL Shell and run it, as described in Exercise: Running Your First Query.

    Note the results in one of the data cells; for example, notice that the first tuple, ([100-10],[East],[Sales],[Qtr1]), has a value of 5731.

  3. Add a slicer axis to limit the data returned to budgeted values only.

    SELECT
      CrossJoin ({[100-10]}, {[East],[West],[South],[Central]})
    ON COLUMNS,
      CrossJoin (
        {[Sales],[COGS],[Margin %],[Profit %]}, {[Qtr1]}
      )
    ON ROWS
    FROM Sample.Basic
    WHERE (Budget)
  4. Paste the query into the MaxL Shell and run it.

  5. Save the query as qry_slicer_axis.txt.

Results: You should see different results for the queries listed in step 1 and step 3.