Filter data using the context area

You can filter the data in a TM1® Exploration View using the context area. You can filter using dimensions, members, and sets.

About this task

Changing context changes the values that appear. It does not limit or change the members in the rows or columns.

For example, you have an Exploration View showing products in the rows and months in the columns. To change the context to Asia, you drag Asia from the source tree to the Context drop zone in the overview area. The Exploration View then shows only the values for Asia.

You can filter using multiple values in the context area. For example, you can drag Asia and Franchise Stores to the context area. The Exploration View then shows only the values for franchise stores in Asia.

Procedure

  1. Create an Exploration View using a TM1 data source.
  2. In the source tree, select one or more items to filter on.
    • To filter using a dimension, select the dimension. The default member of the dimension is used for the filter.
    • To filter using a set, expand the dimension, expand Subsets, and select a set. The default member of the set is used for the filter.
    • To filter using a member, expand the dimension, expand Members, and select the member.
  3. Drag the item you selected to the Context drop zone.

Results

The values in the Exploration View are filtered using the items you selected.

Notice that each item has a down-arrow beside it. Click the down arrow to see options for deleting or changing the context member. For example, if you filtered using a set, you can click the down-arrow to select a different member of the set to use in the filter.