Skip Headers

Oracle® Health Sciences Pharmacovigilance Operational Analytics User and Administrator Guide Release 1.0 E23554-01 |
Home | Book List | Contents | Index | Contact Us

Previous | Next
| PDF · Mobi · ePub

# 3 Working with Reports

Using Oracle BI Analysis, you can run or display predefined reports (delivered with OPVA), and you can also create or modify custom reports.

This chapter contains the following topics:

- Pre-defined Reports

- Custom Reports

- Viewing Reports With Your Apple iPhone

## 3.1 Pre-defined Reports

OPVA is delivered with a bunch of pre-defined reports. A subset of these reports is displayed on your dashboard pages, based on the user group you are assigned to.

A report can contain data in a tabular format, pivot table, or graph. You can filter the data visible on the report based on certain criteria such as Program, Study, Users, User Group, etc. These filters are called prompts. Some reports let you drill down to a more detailed report.

The following is a list of some report-related tasks that you can perform:

- Create and modify reports

- Refresh the results

- Print and Save reports

- Add reports to the briefing book

- Copy reports

See Also:

- Chapter 2, "Using OPVA" for more information about report-related tasks.

- Appendix A, "Dashboards and Reports" for more information about predefined reports.

- Oracle Health Sciences Pharmacovigilance Operational Analytics Installation Guide for instructions on installing OPVA.

### 3.1.1 Opening and Using Dashboards

Perform the following steps to open and use dashboards:

1. In the global header, click Catalog to view the Catalog page.

2. Navigate to the dashboard and click the Open link. The dashboard is opened to the first Dashboard Page. If no content has been added, an Empty Dashboard Page notification message is displayed.

3. This is an optional step - You may choose to perform any of the following tasks:

   1. Display the dashboard in the Dashboard Builder for editing.

   2. Navigate among dashboard page by clicking the page tabs.

   3. Print a page.

   4. Refresh a page.

Perform this to ensure that the refresh operation bypasses saved information in the Oracle BI Presentation Services cache and is issued to the Oracle BI Server for processing.

When you select a specific dashboard or analysis, Presentation Services checks its cache to determine if the identical results have recently been requested. If so, Presentation Services returns the most recent results, thereby avoiding unnecessary processing by the BI Server and the back-end database. If not, the analysis is issued to the BI Server for processing. You cannot force the analysis past the BI Server's cache.

Administrators can configure cache settings that control what is cached and for how long. For information, refer to Managing Performance Tuning and Query Caching in the Oracle Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edition.

## 3.2 Custom Reports

You can create a custom report if you have been assigned the required permissions and responsibilities. If you prefer, you can copy a pre-defined report and use it as a template for the new report.

Use the Oracle BI Answers user interface to create your own report. But before you proceed, consider the following points:

- Do not modify a pre-defined report. If you do, your changes will be overwritten when a new release of OPVA is installed. Alternatively, you can make a copy, and modify the copy.

- Define a Catalog Folder hierarchy that gives each Answers user, a unique folder tree. Limit the right to move requests into public folders to members of the OPVA Administrators group.

- Limit the right to place requests onto shared dashboards to members of the OPVA Administrators group.

## 3.3 Viewing Reports With Your Apple iPhone

To download Oracle Business Intelligence Mobile, tap the App Store icon on the Home screen of your iPad or iPhone.

Alternatively, you can download the application from your computer through iTunes and then synchronize your iPad or iPhone.

Performs the following steps to download and install Oracle Business Intelligence Mobile:

- On your device, go to iTunes, and search the App Store for 'Oracle'.

- From the displayed search results, select the Oracle Business Intelligence Mobile application, and tap the Install button.