Skip Headers
Oracle® Business Intelligence Enterprise Edition Help
11g Release 1 (11.1.1)
  Go To Table Of Contents
Contents

Adding Oracle BI Publisher Reports to Dashboard Pages

This section describes how to add Oracle BI Publisher reports to dashboard pages. It contains the following topics:


Note:

If you use Microsoft's Internet Explorer browser version 7, then you might experience problems viewing BI Publisher reports that are embedded in analyses or dashboards, depending on the privacy settings of the browser. When you display the page from Oracle BI EE in the browser, you might find that the BI Publisher report is missing. This problem is encountered on browsers with a medium-level of privacy and popups blocked. To work around this problem, use a different browser than Internet Explorer version 7, or view the report in BI Publisher rather than in Oracle BI EE, or reduce the privacy setting of the browser.


How Do Oracle BI Publisher Reports and Dashboard Pages Interact?

This section contains the following topics:

About Oracle BI Publisher and Dashboard Pages

This section contains the following topics:

For general information on BI Publisher, see "Integration of Oracle BI EE with Oracle BI Publisher."

Interacting with Reports on Dashboard Pages

You can run, view, and interact with a BI Publisher report on a dashboard page. When included on a dashboard page, the BI Publisher report can include a toolbar that can offer options for selecting a layout template, changing the BI Publisher report's output format, exporting the BI Publisher report, sending the BI Publisher report to an available destination (for example, printer, fax, email, or FTP), scheduling the BI Publisher report, and analyzing the data.

About Briefing Books and Printing BI Publisher Reports

If you plan to print a dashboard page that contains a BI Publisher report or to include the page in a briefing book, then you must keep the following points in mind:

  • If you print the briefing book as PDF and if the output format of the BI Publisher report is PDF, then the BI Publisher report is printed after the other objects on the page. If you print a dashboard page that contains a BI Publisher report as PDF, but the dashboard page is not part of a briefing book, then the BI Publisher report is not printed.

  • If you print the dashboard page or briefing book as MHTML, then the BI Publisher report is not printed.

About Adding Reports to 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.

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

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

  • The agent must be set to deliver PDF.

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 BI EE.

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

Adding Reports to Dashboard Pages

To add a report to a dashboard page:

  1. Edit the dashboard. For information, see "Editing Dashboards."

  2. Navigate to the page to which you want to add a report.

  3. Select a report in one of the following ways:

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

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

  4. 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.

    The "BI Publisher Report Properties dialog" is displayed.

  5. Complete the fields in the properties dialog as appropriate.

  6. Click OK.

  7. Click Save.

  8. If required, add a prompt to the dashboard page to filter the results of an embedded parameterized report, as described in "Using Prompts with Parameterized Reports."

  9. Optionally, schedule the dashboard with an agent, as described in Chapter 8, "Delivering Content."

Using Prompts with Parameterized Reports

You can use prompts to filter the results of embedded parameterized BI Publisher reports to show only results that match the prompt criteria.

The BI Publisher report can be either of the following:

  • A BI Publisher report that receives its data from an Oracle BI EE analysis. For this report, you must have the report columns to filter on set to "Is Prompted" in the analysis. This type of report supports the full range of prompt expressions.

  • A BI Publisher report that was created using a direct connection to a subject area. For more information on creating a report using a direct connection to a subject area, see "Creating Reports Using a Direct Connection to a Subject Area" in Report Designer's Guide for Oracle Business Intelligence Publisher.

To use prompts with parameterized reports:

  1. In BI Publisher, open the report and locate the parameters that it uses. Set a default value for each required parameter so that the report displays correctly without user interaction.

  2. Create a new column prompt for each parameter by following these steps:

    1. In the global header, click New, then Dashboard Prompt.

    2. Select either the subject area that includes the columns from the report or a subject area whose columns closely match those in the report.

    3. In the "Definition pane," click the New button, select Column Prompt, then select a column to use for the prompt. If the BI Publisher report was created using a direct connection to a subject area, make sure that you select the same column that you selected in the BI Publisher report.

    For more information on creating prompts, see Chapter 6, "Prompting in Dashboards and Analyses."

  3. Complete the "New Prompt: Column dialog" and click OK. Verify the following settings:

    • Set the Operator field to is equal to/is in.

    • Define a presentation variable with the exact same name as the parameter from the report. When using variable names in prompts, ensure that you spell them correctly and adhere to case-sensitivity. Make the data type of the parameter match the data type of the column, if they are not based on the same database column.

    • If the BI Publisher report was created using a direct connection to a subject area, specify the value of the variable using the following format:

      "Subject Area Name"."Folder Name"."Column Name"
      

      For example:

      "Sample Sales Lite"."Time"."Per Name Year"
      

      If the column is in a nested folder, list all folders. For example:

      "Sample Sales Lite"."Time"."More Time Objects"."Day of Week"
      
  4. Click the Save Prompt toolbar button to save the prompt to the catalog in a shared folder.

  5. Navigate to the dashboard that contains the parameterized report and click the Edit Dashboard toolbar button.

    The "Dashboard builder" is displayed.

  6. In the Catalog pane, navigate to the folder that contains the prompt to add.

  7. Drag and drop the prompt into the section on the dashboard page that contains the report.

  8. Click the Save toolbar button.