Filtering the data set

Use the Filter button to select elements from other available dimensions to further filter the data set. The dimensions displayed in the Filter window do not include the dimension that the widget is already showing. For example, if the widget shows the Period dimension, then the Period dimension is not included in the Filter window.

  1. Click the Filter button of the widget. The dimensions available are displayed.
  2. For dimensions with list views, click the drop-down arrow and select an element from the list. Filters with interdependencies or lists with fix values are displayed in list views.
  3. For dimensions with lookup objects, click the Lookup button and drill down to the element that you want to filter. You can also specify the element in the Find field and click the Filter button.
  4. Click OK.Filter lookup screenshot