Create context filters

In this topic, you will learn how to create context filters by dropping members or sets in the context filter area.

It should take 15 to 20 minutes to complete this topic. To view the completed report, download the CustomFilter.xls sample workbook.

Procedure

  1. Create a new Exploration View that uses the Sales and Marketing (cube) package.
  2. Insert data in the Exploration View:
    • In Measures, drag Returns to the Measure drop zone.
    • Drag Products to the Rows drop zone.
    • In Time, drag Time to the Columns drop zone.
  3. Change the label in the Time column to Total.
  4. Show all the members in the levels.
  5. In Retailers, drag Americas to the Context drop zone.
  6. In Order method, drag Web to the Context drop zone.

    You see the returns only for the Web in the Americas territory for all the product brands over a four-year span. The total number of returns is visible in the Total column.

  7. Continue with creating custom filters.