Obiee 简明教程

OBIEE – Prompts

提示是一种特殊类型的过滤器，用于过滤嵌入在仪表盘中的分析。使用仪表盘提示的主要原因是，它允许用户自定义分析输出，还允许灵活地更改报告的参数。可以使用的三种类型的提示如下：

A Prompt is a special type of filter that is used to filter analyses embedded in a dashboard. The main reason to use a dashboard prompt is that it allows the user to customize analysis output and also allows flexibility to change parameters of a report. There are three types of prompts that can be used −

Named Prompts

在仪表盘级别创建的提示称为命名提示。此提示是在特定仪表盘外部创建的，并作为提示存储在目录中。你可以将命名提示应用于任何包含提示中提到的列的仪表盘或仪表盘页面。它可以过滤嵌入在同一仪表盘页面上的一个或任意数量的分析。你可以创建这些命名提示并将其保存到私有文件夹或共享文件夹。

The prompt created at the dashboard level is called a Named prompt. This Prompt is created outside of a specific dashboard and stored in the catalog as a prompt. You can apply a named prompt to any dashboard or dashboard page that contains the columns, mentioned in the prompt. It can filter one or any number of analyses embedded on the same dashboard page. You can create and save these named prompts to a private folder or a shared folder.

命名提示始终显示在仪表盘页面上，用户可以提示不同的值，而无需重新运行仪表盘。命名提示还可以与选择步骤交互。你可以指定仪表盘提示以覆盖特定的选择步骤。

A named prompt always appears on the dashboard page and the user can prompt for different values without having to rerun the dashboard. A named prompt can also interact with selection steps. You can specify a dashboard prompt to override a specific selection step.

该步骤将针对用户使用仪表盘列提示收集的用户指定数据值处理仪表盘列，而所有其他步骤将按照原始指定进行处理。

The step will be processed against the dashboard column with the user-specified data values collected by the dashboard column prompt, whereas all other steps will be processed as originally specified.

Inline Prompts

内联提示嵌入在分析中，并且不会存储在目录中以便重复使用。内联提示提供对分析中列的一般过滤，具体取决于其配置方式。

Inline prompts are embedded in an analysis and are not stored in the catalog for reuse. Inline prompt provides general filtering of a column within the analysis, depending on how it is configured.

内联提示独立于仪表盘过滤器工作，该过滤器确定仪表盘上所有匹配列的值。内联提示是初始提示。当用户选择提示值时，提示字段会从分析中消失。

Inline prompt works independently from a dashboard filter, which determines values for all matching columns on the dashboard. An inline prompt is an initial prompt. When the user selects the prompt value, the prompt field disappears from the analysis.

若要选择不同的提示值，你需要重新运行分析。你的输入决定了嵌入在仪表盘中的分析的内容。

To select different prompt values, you need to rerun the analysis. Your input determines the content of the analyses embedded in the dashboard.

命名提示可以应用于任何包含提示中指定的列的仪表盘或仪表盘页面。

Named Prompt can be applied to any dashboard or dashboard page which contains the column specified in the Prompt.

Column Prompts

列提示是最常见且最灵活的提示类型。列提示允许你构建非常具体的价值提示，以便独立出现在仪表盘或分析中，或扩展或细化现有的仪表盘和分析过滤器。可以在分析或仪表盘级别为层次结构、度量或属性列创建列提示。

A column prompt is the most common and flexible prompt type. A column prompt enables you to build very specific value prompts to either stand alone on the dashboard or analysis or to expand or refine existing dashboard and analysis filters. Column prompts can be created for hierarchical, measure, or attribute columns at the analysis or dashboard level.

转到“新建”→“仪表盘提示”→“选择主题区域”。

Go to New → Dashboard Prompt → Select subject area.

column prompts

将显示仪表盘提示对话框。转到“+”号，选择提示类型。单击列提示 → 选择列 → 单击“确定”。

Dashboard prompt dialog box appears. Go to ‘+’ sign, select the prompt type. Click on the column prompt → Select column → Click OK.

dashboard prompt

将出现“新建提示”对话框（仅适用于列提示）。输入将出现在仪表盘提示旁边的标签名称 → 选择运算符 → 用户输入。

New Prompt dialog box appears (this appears only for column prompts). Enter the label name that will appear on dashboard next to Prompt → Select the Operator → User Input.

new prompt

在列和变量提示中，显示“用户输入”字段的下拉列表，让你可以为用户界面确定“用户输入”方法。你可以选择下列任何一项：复选框、单选按钮、选择列表或列表框。

The User Input field’s drop-down list appears for column and variable prompts, and provides you with the option to determine the User Input method for the user interface. You can select any of the following − checkboxes, radio buttons, a choice list, or a list box.

Example - 如果你选择“用户输入”方法中的“选择列表”和“选择列表值”项，则用户将从包含数据源中所有数据值的列表中选择提示的数据值。

Example − If you select the User Input method of Choice List and Choice List Values item of all Column Values, the user will select the prompt’s data value from a list that contains all of the data values contained in the data source.

你还可以通过展开“选项”选项卡来进行进一步的选择。

You can also further make a selection by expanding the Options tab.

options tab

这些系列复选框允许你限制输出中返回的数据量。一旦进行选择，请单击确定。

These series of checkboxes allow you to restrict the amount of data returned in output. Once selection is made, click OK.

该提示将添加到“定义”→ 保存提示（使用右上角的保存选项）→ 输入名称 → 单击确定。

The Prompt is added to Definition → Save the prompt using the save option at the top right corner → Enter the name → Click OK.

save prompt

若要测试该提示，请转到“我的仪表板”→ 目录，并将提示拖至列 1。可以通过单击属性 → 范围将该提示应用于整个仪表板或单个页面。

To test the Prompt, go to My Dashboard → Catalog and drag the prompt to column 1. This prompt can be applied to full dashboard or on a single page by clicking on Properties → Scope.

test prompt

保存并运行仪表板，选择一个为 提示选择的值。根据提示值，将应用输出值并将发生更改。

Save and run the Dashboard, select the value for a Prompt. Apply and Output value will change as per prompt value.

Other Prompts

Currency Prompt

币种提示使用户能够更改分析或仪表板上币种列中显示的币种类型。

A currency prompt enables the user to change the currency type that is displayed in the currency columns on an analysis or dashboard.

Example - 假设分析以美元为单位包含了美国某个特定地区的销售总额。但是，因为查看分析的用户居住在加拿大，所以他们可以使用币种提示将销售总额从美元更改为加拿大元。

Example − Suppose that an analysis contains the sales totals for a certain region of US in US dollars. However, because the users viewing the analysis reside in Canada, they can use the currency prompt to change the sales totals from USD to Canada dollars.

该提示的币种选择列表填充自用户的“我的帐户”对话框→“首选项”选项卡中的币种首选项。仅当管理员已配置 userpref_currencies.xml 文件时，才会提供币种提示选项。

The prompt’s currency selection list is populated with the currency preferences from the user’s → My Account dialog → Preferences tab. Currency prompt option is available only if the administrator has configured the userpref_currencies.xml file.

Image Prompt

图片提示提供一张图片，用户单击图片可在分析或仪表板上选择值。

An image prompt provides an image that users click to select values for an analysis or dashboard.

Example - 在销售组织中，用户可以单击地图图片中的区域来查看销售信息，或单击产品图片来查看有关该产品的信息。如果你知道如何使用 HTML <map> 标记，则可以创建一个图片地图定义。

Example − In a sales organization, users can click their territories from an image of a map to see sales information, or click a product image to see sales information about that product. If you know how to use the HTML <map> tag, then you can create an image map definition.

Variable Prompt

变量提示使用户可以选择指定为变量提示值的值，以在仪表板上显示。变量提示不依赖于列，但仍然可以使用列。

A variable prompt enables the user to select a value that is specified in the variable prompt to display on dashboard. A variable prompt is not dependent upon a column, but can still use a column.

Add Reports to BI Dashboard Pages

你可以将一个或多个现有报告添加到仪表板页面。这样做的好处是，你可以与其他用户共享报告，并使用代理程序安排仪表板页面。代理程序会将整个仪表板发送给用户，包括报告引用的所有数据页面。

You can add one or more existing reports to a dashboard page. The advantage is that you can share reports with other users and schedule the dashboard pages using agents. An agent sends the entire dashboard to the user, including all data pages that the report references.

为包含 BI Publisher 报表的仪表板页面配置代理程序时，请确保满足以下条件：

When configuring an agent for a dashboard page that contains a BI Publisher report, ensure that the following criteria are met −

  1. The output format of the BI Publisher report must be PDF.

  2. The agent must be set to deliver PDF.

你可以以嵌入式内容或链接的形式将报表添加到仪表板页面。嵌入意味着该报表直接显示在仪表板页面上。该链接会在 Oracle BIEE 中的 BI Publisher 中打开报表。

You can add reports to a dashboard page as embedded content and as a link. Embedded means that the report is displayed directly on the dashboard page. The link opens the report in BI Publisher within Oracle BIEE.

如果你在 BI Publisher 中修改了报表并保存了更改，请刷新仪表板页面，以查看修改。导航到要向其添加报表的页面。

If you modify the report in BI Publisher and save your changes, then refresh the dashboard page to see the modifications. Navigate to the page to which you want to add a report.

Add a BI Report to a Dashboard Page

通过以下其中一种方式选择一份报表：

Select a report in one of the following ways −

  1. Select the report from the Catalog pane and drag and drop it into a section on the dashboard page.

  2. To add a report from a dashboard page, select the report from the folder that contains its dashboard in the Catalog pane.

设置对象的属性。为此，请将鼠标指针悬停在页面布局区域中的对象上，以显示对象的工具栏，然后单击“属性”按钮。

Set the properties of the object. To do so, hover the mouse pointer over the object in the page layout area to display the object’s toolbar, and click the Properties button.

将显示“BI Publisher 报告属性”对话框。在属性对话框中填写相应的字段。单击“确定”，然后单击“保存”。

The "BI Publisher Report Properties dialog" is displayed. Complete the fields in the properties dialog as appropriate. Click OK and then click Save.

如果需要，请向仪表盘页面添加一个提示，以筛选嵌入参数化报告的结果。

If required, add a prompt to the dashboard page to filter the results of an embedded parameterized report.