Obiee 简明教程

OBIEE – Filters

过滤器用于限制分析运行时显示的结果，以便结果回答特定问题。基于这些过滤器，只会显示与过滤器条件中传递的条件匹配的结果。

Filters are used to limit the results that are displayed when an analysis is run, so that the results answer a particular question. Based on the filters, only those results are shown that matches the criteria passed in the filter condition.

过滤器 直接应用于属性和度量列。过滤器在查询聚合之前应用，并影响查询，从而影响度量的结果值。

Filters are applied directly to attribute and measure columns. Filters are applied before the query is aggregated and affect the query and thus the resulting values for measures.

例如，您有一个成员列表，其中聚合总和为 100。随着时间的推移，更多的成员满足设定的筛选条件，这将使聚合和增加到 200。

For example, you have a list of members in which the aggregate sums to 100. Over time, more members meet the set filter criteria, which increases the aggregate sum to 200.

Column Filters

以下是创建过滤器的几种方法：

Following are the ways to create filters −

Create a Named Column Filter

  1. 转到 Oracle Business Intelligence 主页→新建菜单→选择过滤器。将显示“选择主题区域”对话框。

Go to Oracle Business Intelligence homepage → New menu → Select filter. The Select Subject Area dialog is displayed.

  1. 在“选择主题区域”对话框中，选择要为其创建过滤器的主题区域。“主题区域窗格”中会显示“过滤器编辑器”。双击要为其创建过滤器的列。将显示“新建过滤器”对话框。

From the Select Subject Area dialog, choose the subject area for which you want to create a filter. The "Filter editor" is displayed from the "Subject Areas pane". Double-click the column for which you want to create the filter. New Filter dialog is displayed.

Create an Inline Filter

  1. 创建分析或访问要为其创建过滤器的现有分析。

Either create an analysis or access an existing analysis for which you want to create a filter.

  1. 单击“条件”选项卡→找到“过滤器窗格”→单击为当前主题区域按钮创建过滤器。分析选择的列显示在级联菜单中。

Click the Criteria tab → Locate the "Filters pane" → Click create a filter for the current subject area button. The analysis selected columns are displayed in the cascading menu.

  1. 从菜单中选择列名称或选择“更多列”选项以访问“选择列”对话框，从中可以选择主题区域中的任何列。

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.

  1. 选择列后，会显示“新建过滤器”对话框。

Once you select a column, the "New Filter dialog" is displayed.