- Using Oracle Business Intelligence or Oracle Analytics for Oracle Taleo Enterprise Edition
- Creating a Column Filter
Creating a Column Filter
Before you start
BI Author Limited
BI Author Developer
BI Tenant Administrator
Home > Oracle Analytics
Here's what to do
-
Note: If your repository is configured for double columns, and you want to use an operator other than is equal to / is in, is not equal to / is not in, or is between and specify code values rather than display values, then you should explicitly choose the code column rather than the display column.To create a named filter, use the following sub-procedure:
- From the Oracle Business Intelligence Home page, locate the global header, hover over the New menu, and from the menu select Filter. The Select Subject Area dialog is displayed.
- From the Select Subject Area dialog, choose the subject area for which you want to create a filter.
- From the Subject Areas pan, double-click the column for which you want to create the filter.
- To create an inline filter, use the following sub-procedure:
- Either create an analysis or access an existing analysis for which you want to create a filter. Click the Criteria tab.
- Locate the Filters pane and from the Filters Pane's toolbar, click the Create a filter for the current subject area button. The analysis' selected columns are displayed in the cascading menu.
- Select a column name from the menu. Or select the More
Columns option to access the Select Column dialog from which you can
select any column from the subject area.
After you selected a column, the New Filter dialog is displayed.
-
Note: If you want to add a filter for a column located in a different subject area, then you must first add that subject area to the analysis by clicking the Add/Remove Subject Area button in the Subject Areas pane.In the Operator field, choose an operator for the filter. The operator list from which you can choose is populated based on the type of column that you selected.
- In the Value field, specify one or more values to use when
applying the filter or condition. You can:
Type values, using a semicolon to separate the values.
-
Select values from the list or calendar.
To search for specific values, click Search in the list box.
If your repository is configured for double columns, and you are creating the filter on a display column, then by default, you specify display values. However, if your organization allows the display of code values, then you can specify code values rather than display values, but only if you use one of the following operators:
is equal to / is in
is not equal to / is not in
is between
To specify code values, select the Select by Code Column box and then specify the values.
- If your repository is configured for double columns, and you are creating the filter on a display column and want to filter on display values rather than code values, then deselect the Filter by Code Column box.
- Click the Add More Options button to add a SQL expression, Session variable, Repository variable, or Presentation variable to the filter. Note that if you are setting the filter's value with a SQL expression or variable, you should leave the Value field blank.
- Select the Protect Filter box to protect the filter's value from being overridden by a matching prompt's value or when the user navigates to another report within the analysis. When you navigate from one report to another report within an analysis, any prompt values that you specified in the first report can be transferred to the second report.
-
Note: This is a one-way conversion. After you select the Convert this filter to SQL box, you can no longer view and edit the filter in the Edit Filter dialog. After you convert the filter to SQL statements, you can only view and edit the filter item as SQL statements in the Advanced SQL Filter dialog.To convert the filter to SQL statements, select the Convert this filter to SQL box.
For more information about this option, see "Creating and Editing the SQL Statements for a Column Filter in an Analysis"
. - When you are finished specifying the filter's criteria, click OK.
- Save the filter in one of the following ways:
From the Analysis Editor, you can select Save Analysis to save the filter as an inline filter.
From the Filter Editor, you can select Save Filter to save the filter as a named filter.
For more information, see "Inline or Named Objects".