P109 Primavera P6 Reporting using Oracle BI Publisher


After completing this course, you will be able to describe and identify business intelligence within the Primavera landscape. This course will teach you how Oracle Business Intelligence (BI) products integrate with P6 and shows you how it can be used to fulfil your P6 and enterprise reporting requirements.

By enrolling in this course, you'll explore the P6 Extended Schema in detail, which includes an explanation of how to use the Oracle SQL Developer Data Modeler. A case study at the end of the course tests your ability to build reports.

Learn To:

Create reports.
Build new data models.
Create and customize layouts.
Edit P6 sample reports, as well as existing reports.
Use BI Publisher with P6 Analytics.
Analyze the P6 Extended Schema.

Topics Include:

Navigating and Viewing Reports
Accessing Account Preferences
Accessing the P6 Reports Section

Creating Reports Using Existing Data Models
Selecting a Data Model
Adding and Saving a Layout
Setting Ouput Formats

Working with the P6 Extended Schema
Understanding the P6 Extended Schema
Using the Oracle SQL Developer Data Modeler

Constructing New Data Models
Setting a Default Data Source
Adding a Data Set
Building a SQL Query
Adding a Layout and Viewing the Report
Adding a List of Values and a Parameter

Customizing Layouts
Using the Layout Editor
Customizing Layouts Using BI Publisher

Editing P6 Sample Reports
Viewing P6 Sample Reports
Editing P6 Sample Reports

Using BI Publisher with P6 Analytics
Adding BI Publisher Reports to a Dashboard
Creating a Report Based on P6 Analytics Analyses

Scheduling Reports in P6
Scheduling Reports in BI Publisher

Sign up to get immediate access to this course plus more you can watch anytime, anywhere. Subscribe Today!
Already a subscriber? Sign In

Build a website with PageLines
Ready to Learn?
Get started
Already a Member?
Sign In