Adding P6 Sample Reports

You can use P6 sample reports to test the functionality of your BI Publisher integration.

Note: The BI Publisher sample reports were designed to be run against the small data set included in the sample database. These reports are provided as an example of the product’s capability only. Oracle provides no guarantee, implied or explicit, that the BI Publisher sample reports will run against your database or will produce meaningful data when they are run against your database. You may modify the BI Publisher sample reports to suit your own data set, including adding filter criteria to limit data output or changing filter criteria to suit your data. You need a full BI license to modify sample reports.

To add sample reports:

  1. Copy P6Reports.zip from the P6 media pack to the BI Publisher server.
  2. Extract the contents of P6Reports.zip.
  3. Note the location of the P6Reports.xdrz file in the BIPP6reportsOracle (for Oracle) or BIPP6reportsSQLServer (for Microsoft SQL Server) folder.
  4. Log in to BI Publisher as an administrative user.
  5. Upload the P6Reports.xdrz file:
    1. Click Catalog Folders.
    2. Click Shared Folders, and then click Upload in the Tasks pane.
    3. In the Upload window, click Browse, and then navigate to the location of the P6Reports.xdrz.
    4. Select P6Reports.xdrz, and then click Open.
    5. Click Upload.
    6. Verify that the P6Reports folder is present under Shared Folders.

Related Topics

Using the Oracle Fusion Middleware Security Model

Creating the JDBC Connection String for BI Publisher

Adding the JDBC Data Source to the BIConsumers Role

Assigning Permissions to the P6Reports Catalog Folder

Creating a Reporting Admin User in BI Publisher for P6 EPPM for Fusion Middleware Security

Creating Reporting Users in BI Publisher for P6 EPPM for Fusion Middleware Security

Setting the Data Source for Each Sample Report for BI Publisher



Legal Notices | Your Privacy Rights
Copyright © 1999, 2021

Last Published Tuesday, December 7, 2021