Using the Element Browser in a worksheet

You use the Element Browser option to apply a simple filter for elements that must be displayed in a worksheet.

To use the Element Browser:

  1. In a worksheet, select a dimension header or one of the elements on the pivot.
  2. Right-click the selected entity and click Element Browser.
  3. In the Element Browser window, in the Filter section, specify this information:
    Attribute
    Select an attribute available in OLAP for the selected dimension.
    Filter Text
    Enter text to create a simple filter.
  4. In the Display section, specify this information:
    Current Selection
    The current selection is applied.
    Ad Hoc Total
    Select this option to apply the filter to the worksheet. By default, the sum of the selected elements is displayed.
    Note: You must expand this section to view these options.
    The Selection section displays the results based on the specified filter. The results are displayed in a hierarchical format and, by default, all elements are selected. The filter supports the simple 'Contains' filter.
  5. Click OK to apply the filter to the worksheet, based on the option selected in the Display section.
    Note: The Ad Hoc Total option is disabled when the Element Browser is accessed using a Scenario dimension.