Adding a filter

You can add a data filter to a Word document.

  1. Click where to add a filter in the document.
  2. Click Filter.
  3. Select a data connection.
  4. Select a cube.
  5. Select dimension or hierarchy.
  6. Optionally, click the Display Format icon and select which element attribute to display.
    By default, the element caption is selected.
  7. Optionally, click the Element Visibility icon and select which of these elements to show:
    Option Description
    All Elements By default, all elements of the selected hierarchy are available for selection.
    Selected Elements Only selected elements are displayed.
    Leaf Elements Only the base elements are displayed.
    Elements from Level All levels are listed from the top level to the base level. If you select Level 0, the top elements are displayed. Or, if you select Level 1, all children of one or more top elements are displayed.
    To look for specific elements, click the Search icon and specify all or part of an element name in the search box.
  8. To select elements other than the default element of the hierarchy, select the check boxes of the required elements.
    You can select one or more elements. To select all visible elements, expand the elements and select the check box in the list header.
  9. Click Add.