8 Generating and Scheduling Standard Reports - BIP

Argus Insight provides built-in Reports that you can run on active case series to analyze your company's safety, workflow, and product data.

In addition to the preformatted and predefined BIP standard reports, you can create custom reports using the BI Publisher tool. For more information, see Chapter 9, "Creating Custom Reports - BIP."

8.1 About BIP Standard Reports

Although BIP standard reports are predefined reports, you can define pre-filters before generating a BIP standard report to have the report output display information only about specific types of cases. Pre-filters let you narrow down the case series further so that the system runs the report only on those cases that conform to the pre-filter criteria.

For example, suppose your case series consists of cases that were reported in all countries for a particular product. However, you only want information about cases reported in the United States. In this case, you can specify a pre-filter such that the report output includes only those cases that were reported in the United States.

8.1.1 Case Series, ETL, and Association

Because a case series might become obsolete each time the data mart is refreshed by running an ETL, you may need to generate the case series again before generating a BIP standard report.

Alternatively, you can directly associate a query (QBE, filter, or advanced condition) to a BIP standard report to avoid manual generation of the case series.

8.1.2 Browser Configuration

Before using Argus Insight to generate reports, configure the browser as defined in the Oracle Argus Insight Installation Guide.

8.1.3 Report Cover Page

The report cover page has three main sections:

  • Page header

  • Page contents

  • Page footer

You can customize some of the information on the report cover page. The sections that follow provide more information about each component of the cover page.

8.1.3.1 Page Header

The page header of the report cover page includes the following information:

  • Company logo. The upper-left box is a placeholder for a logo. You can configure your company logo to print in this space.

  • Name of the category to which the selected report belongs. For example, Compliance, Management, or Pharmacovigilance.

  • Date and time (Greenwich Mean Time [GMT]) that the report was run.

8.1.3.2 Page Contents

The page contents of the report cover page includes the following information:

  • Title of the selected report.

  • Report subtitle. You configure the subtitle when you run the report. Subtitles are useful in further defining the contents of the report. For example, 01-JAN-2000 to 31-DEC-2012.

  • Filters defined for the selected report.

  • Start date and time (GMT) of the last successful ETL run.

  • Count of the total number of unique cases in the case series.

  • Name of the saved case series on which the report has been executed.

    • Reports that are run on frozen case series data include the following text next to the case series name on the report:

      The data in this report was frozen as of date_and_time.

      Time is the database system time with the GMT offset.

    • Reports that are run on normal case series data include the following text next to the case series name on the report:

      The case series was last modified on date_and_time.

  • Query criteria to get case series on which the report has been executed.

8.1.3.3 Page Footer

The page footer of the report cover page includes the following information:

  • Name of the user who executed the report.

  • Confidential text. You can configure the text that prints in the center of the page footer.

  • Page number (Page x of y).

In addition, some reports include a placeholder in the footer for another logo. You can configure the image for the logo.

8.2 Working in the Reports Page

The Reports page, lists all the BI Publisher reports built in to Argus Insight.

To display the Reports page:

  1. Select Reporting > BI Publisher.

    The BIP login page appears in new window.

  2. Log on to the BI Publisher tool.

    The BIP Home page appears.

  3. Click Catalog.

  4. In the Folders section, navigate to Shared Folders > Argus Insight > General > Reports.

    The Generic Line Listing Report in LE and RTF formats appears in the right pane.

8.3 Generating Reports

  1. Click the Report link or Open on the Reports page.

    The Generic Line Listing Report-LE page appears.

  2. Enter the values for all the fields and select the Output Type.

  3. Click Apply.

    The values entered are displayed in the generated report.

    For more information on Viewing Reports using the BI Publisher tool, refer to the Viewing a Report section of the Oracle Fusion Middleware User's Guide for Oracle Business Intelligence Publisher.

8.4 Scheduling and Associating Reports Against a Query or Case Series

You may refer to the Creating Report Jobs and Viewing and Managing Report Jobs sections of the Oracle Fusion Middleware User's Guide for Oracle Business Intelligence Publisher for information on Scheduling and Associating Reports against a query or a case series.