
To clear a filter for a selected column, select the filter and click Clear. To clear all filters for all
columns, click Clear All.
You can save the filter that you just created and then apply it to the MEASURES.CHILD column,
so that all children of Measures, except Misc, are included in the report.
➤ To save the filter that you just created:
1 In the Select Data Filters dialog box, click Add new filter.
The Filter Name dialog box is displayed.
2 In the Name text box of the Filter Name dialog box, type the name for the filter that you are creating.
For this tutorial, type All Children of Measures except Misc, as shown in Figure 203.
Figure 203 Naming a Filter in the Filter Name Dialog Box
3 Select the Copy definition of current filter check box.
Selecting Copy definition of current filter gives the filter the same description and conditions as
the filter currently selected in the Select Data Filters dialog box.
4 Click OK.
The filter is added to the list of saved filters in the Filter drop-down list of the Select Data Filters
dialog box.
Optional: If you want to describe the filter, type a short description for the filter in the Description
text box.
5 Click Save Filters.
6 Click Finish to apply the filter to the MEASURES.CHILD column, so that all children of Measures, except
Misc, are included in the report.
Note:
You can also delete or rename filters. See the Spreadsheet Add-in online help for information.
Oracle's Essbase® Integration Services generates the customized drill-through report and
displays the results in a new spreadsheet. The new spreadsheet is added to the workbook before
the current spreadsheet.
186
Using Drill-Through
Kommentare zu diesen Handbüchern