Before getting started, familiarize yourself with the way BI Publisher handles reports. P6 populates its list of reports from the Report Definitions that load from BI Publisher's web services. When you need to create or modify a report, you will use BI Publisher. The documentation on BI Publisher will help you understand how it works. Before continuing with the following sections, you need to learn about the following Report Definitions from the BI Publisher documentation:
The graphic below will help you understand the basic flow between BI Publisher and P6.
BI Publisher Diagram
Item | Description |
---|---|
| Login with BIP Security admin credentials and impersonate a P6 user. |
| Connect to the P6 EPPM Extended Schema with the PXRptUser. The PXRptUser must be in the same instance as the admuser. |
| You can add many other data sources for reports. |
The data source you will work with to create reports will be the P6 EPPM Extended Schema database. Note that the Publication Services populate the tables and views used for reporting in the P6 EPPM Extended Schema. Configure and execute the Publication Services before you run any report that uses the P6 EPPM Extended Schema. For more information on configuring Publication Services, see Working with Publication Services for Reporting, Configuring Publication Settings in Services Settings, and Configuring Publication Services in Services Settings.
Note: Oracle recommends you use the P6 EPPM Extended Schema database for reporting, but you can work with the ODS database instead if you purchased P6 Reporting Database. The P6 Reporting Database is a truly optional add-on component to the P6 EPPM suite, supporting P6 Analytics, third-party reporting tools, off-line analysis, and consolidation of P6 data into larger corporate data warehouses.
Legal Notices
Copyright © 1999, 2015,
Oracle and/or its affiliates. All rights reserved.
Last Published Wednesday, July 29, 2015