What's New
Cumulative Feature Overview Tool
Analytics Installation and Configuration Guides
P6 Reporting Database for ODS Installation and Configuration Guide
About P6 Reporting Database
About the P6 EPPM Extended Schema
About the Operational Data Store (ODS)
About the ODSETL Process
About ODS Security
Fields in the ODS
De-Normalized Fields from P6 EPPM
Prerequisites
P6 EPPM and JRE Requirements
Configuring and Running P6 EPPM Publication Services
Oracle Database Password Requirements
Required Files, Database Instances, Collation Requirements, and Database Locations
Operating System User Permissions
Oracle Client Requirements
Disk Storage Space Requirements
Creating the Oracle Tablespaces
Configuring the Oracle Database Gateway to Link to a P6 EPPM Database on a Microsoft SQL Server System
Installing and Configuring the ODS Database
Installing the ODS Database
Configuring the Oracle ODS Database
Configuring the P6 EPPM Database Connection on an Oracle Instance
Configuring the P6 EPPM Database Connection on a Microsoft SQL Server Database
Configuring the ODS Database Connection
Configuring ETL Settings for ODS
Finishing the Configuration Wizard for ODS
Finishing the ODS Database Configuration
ODS Security Configuration
Upgrading the ODS Database to the Latest Version
Post Installation Administrative Tasks
Securing the odsetl.properties File
Clearing and Refreshing the Data
Creating a Filtered ODS
Scheduling the ODS Database Update
Manually Launching the ODS Database Update Process
BI Publisher Administration Tasks
Overview of BI Publisher
User-Level Security and User Name Restrictions
Installing Oracle BI Publisher
About Configuring P6 Database Connection Settings for BI Publisher
Configuring the JDBC Connection
Copying the P6REPORTS Folder for BI Publisher 11g
Configuring BI Publisher Security
BI Publisher Database Authentication Setup
Setting Up LDAP with BI Publisher
Running the Configuration Utility
Overview of the Configuration Utility for ODS
Running the Configuration Utility for the ODS Database
Configuring the Secure Sockets Layer
Utility Tables, Log Files, and Troubleshooting
Uninstalling P6 Reporting Database
For More Information
P6 Analytics and Star Database Installation and Configuration Guide
Overview of P6 Analytics
About P6 Analytics
About P6 Reporting Database
About the P6 EPPM Extended Schema
About Star Field Mappings
Prerequisites
P6 EPPM and JRE Requirements
Securing Project Superuser
Configuring and Running P6 EPPM Publication Services
Required Files, Database Instances, Collation Requirements, and Database Locations
Operating System User Permissions
Burn Down and Work Planning Subject Area Requirements
Oracle Client Requirements
Disk Storage Space Requirements
Creating the Oracle Tablespaces
Configuring the Oracle Database Gateway to Link to a P6 EPPM Database on a Microsoft SQL Server System
Installing and Configuring the Star Database
Installing the Star Database
Configuring the Star Database
Configuring the P6 EPPM Database Connection on an Oracle Instance
Configuring the P6 EPPM Database Connection on a Microsoft SQL Server Database
Configuring the Star Database Connection
Configuring ETL Settings for Star
Configuring Codes for Star
Dynamic Codes Description
Code Hierarchies Description
Activity Code Descriptions
Project and Resource Code Descriptions
Configuring User Defined Fields for Star
Finishing the Configuration Wizard
Running the STARETL Process
Updating the RPD file
Configuring an Oracle Standard Edition Database
Multiple Data Sources in the Star Database
Adding Up to Three Additional Data Sources to the Star Database
Adding More than Three Data Sources to the Star Database
Adding Codes from Multiple Data Sources into a Star Database
Combining Data Sources if Using Both Oracle and Microsoft SQL Server Data Sources
Star Security Configuration
Adding a New User for P6 Analytics
P6 EPPM Privileges
Including Inactive Resources in the Star Tables
Installing and Configuring Financial Periods
Upgrading to the Latest Version
Upgrading the Star Database
Upgrading the P6 Analytics Catalog
Upgrading the Repository Definition File (.rpd)
Deploying the New Repository Definition (.rpd) to OBI
Updating the Existing P6 Analytics Repository Definition (.rpd)
Creating and Applying an XML Difference file to the .rpd File
Merging Two Repository Definition (.rpd) Files
Upgrading Custom P6 Analytics Reports
Updating the OraclePrimaveraAnalytics.rpd for P6
Running the Configuration Utility
Overview of the Configuration Utility for Star
Running the Configuration Utility for the Star Database
Configuring the Secure Sockets Layer
Utility Tables, Log Files, and Troubleshooting
Uninstalling P6 Reporting Database
For More Information
Security Guidance for P6 Analytics and P6 Reporting Database
Analytics Suite Security Guidance Overview
Safe Deployment of P6 Analytics and P6 Reporting Database
Administrative Privileges Needed for Installation and Operation of P6 Analytics and P6 Reporting Database
Physical Security Requirements for P6 Analytics and P6 Reporting Database
Files to Protect after Implementing P6 Analytics and P6 Reporting Database
Authentication Options
Authorization for P6 EPPM and P6 Reporting Database
Confidentiality for P6 Analytics and P6 Reporting Database
Reliability for P6 Analytics and P6 Reporting Database
Sensitive Data for P6 Reporting Database and P6 Analytics
About Security in P6 Reporting Database
About Star Security
P6 Analytics Security Guidance
For More Information
P6 Analytics and P6 Reporting Database Planning and Sizing Guide
Overview of Planning Your Implementation
About Oracle Primavera P6 Enterprise Project Portfolio Management
About P6 Analytics
About P6 Reporting Database
Working with Oracle Primavera P6 EPPM, P6 Analytics, and P6 Reporting Database
Critical Performance Factors
Planning Process
Requirements Phase
Using Oracle Database Enterprise Edition (without partitioning) for the Star Schema
Key Questions to Ask about Operational Reporting
Key Questions to Ask about P6 Analytics/Business Intelligence
Planning Phase
Physical Sizing
Overview of Physical Space Usage
Table Partition for Multiple Data Source and History Data
Physical Components
ETL Process Server
Calculating Spread Sizes
Queries for Spread Sizing
Estimating the Size of the Star Database
Estimating the Size of the ODS Database
Oracle Star Database
Physical Hardware
Monitoring Dimension and History Level Impacts on the Database
Consideration for ETL Performance
Summary of Physical Hardware Sizing
Planning Revisited
Planning for P6 EPPM's Impact on Star
Choosing Between Standard Edition and Enterprise Edition
P6 Extended Schema's Affect on Star
Multiple Star Environments
Creating Multiple Data Sources for a Single Star Database
Single Star, Single Data Source, Multiple ETLs
Appendix: Checklists
Checklist for P6 Analytics and the Star Database
Pre-installation for an Oracle Platform
Pre-installation for a Microsoft SQL Server Platform
Pre-installation for Configuring the ETL Server
Pre-installation for the Star Database
Installation: Installer And Configuration
Installation: Running The Processes
Post-installation: After The Processes Complete
Database Scripts For Validations
Checklist for ODS Database
Pre-installation for an Oracle Platform
Pre-installation for a Microsoft SQL Server Platform
Pre-installation for Configuring the ETL Server
Pre-installation for the ODS Database
Installation: Installer And Configuration
Installation: Running The Processes
Post-installation: After The Processes Complete
Database Scripts For Validations
For More Information
Post Installation Administrator's Guide
About the P6 Analytics Post Installation Administrator's Guide
Configuring P6 Analytics
Configuring P6 Analytics with OBI
Overview of OBI
Installing OBI
Prerequisites for Upgrading P6 Analytics
Verifying a TNSNAMES.ora File Exists
Resolving Multiple Oracle Homes to Work with OBI
Verifying the STARDW Alias
Updating the OraclePrimaveraAnalytics.rpd with the Correct Staruser Name and Password
Updating the OraclePrimaveraAnalytics.rpd for P6
Configuring OBI 11.1.1.6 to Use the P6 Analytics Repository Definition (.rpd) and Catalog
Configuring OBI 11.1.1.7 to Use the P6 Analytics Repository Definition (.rpd) and Catalog
Advanced Configurations in P6
About Slowly Changing Dimensions and Daily Snapshot Fact Tables
Configuring a P6 Project for the Burn Down Subject Area
Scheduling a P6 Burn Down Project
Creating Project UDFs for Work Planning Subject Areas
Scheduling a P6 Work Planning Project
Configuring Graded Approach to Schedule Adherence
Setting Up the Sample Database, Repository Definition (.rpd), and Dashboards
Integrating P6 Analytics Data with Map Data to Create Spatial Dashboards
Post Installation Administrative Tasks
Securing the staretl.properties File
Clearing the Data for Star
Refreshing the Data for Star
Creating a Filtered Star
Populate Data Sources with Filtered Project Data
Scheduling the Star Database Update
Manually Launching the Star Database Update Process
History Settings for P6 Reporting Database 3.2
Using Metadata
Backing up the Star Database Nightly
For More Information
Tested Configurations
Analytics User Guides
P6 Analytics Reference Manual
Getting Started
About P6 Analytics
Prerequisites to Use Analytics
About Analyses
About Subject Areas
About Dashboards
Logging in to OBI and Navigating to Dashboards
Editing Sample Analyses
Creating Analyses
Sample Dashboards
Main Dashboard
Portfolio Analysis Dashboard
Overview Page
Project Investment Map Section
Proposed vs. Committed Cost Section
Project Performance by Sponsor Section
Performance Page
Prioritization Page
Risk vs. Reward Section
Project Initiation Section
Rating Section
Project Prioritization - Force Rank by Score Section
Objectives Page
Project Earned Value Dashboard
Project Health Dashboard
Overview Page
Schedule Page
Critical Activities behind Schedule Section
Float Path Section
Labor Performance Section
Completion Section
Percent Complete Analysis Section
Cost Page
History Page
Location Page
At Completion Total Cost by Location Section
Project Code Hierarchy Section
At Completion Labor Units by State Section
Activity Worksheet Page
Resource Analysis Dashboard
Overview Page
Resource Alignment Section
Resource Allocation Section
Labor Hours by Resource Location Section
Over/Under Allocation Section
Staffing Page
Staffing Section
Allocation by Code Section
Hours by Role Section
Total Hours by Team Section
Hierarchies Section
Productivity Page
Resource Utilization by Team Section
Periodic and Cumulative Labor Units by Month Section
Daily vs. Average SPI by Resource Section
Utilization Page
Location Page
Industry Samples Dashboard
Burn Down Activity Use Cases
Burn Down Activity Scenarios
Completed Before Outage Project Snapshot Use Case
Started Before Outage Project Snapshot Spanning into Outage Use Case
Completed Day of Outage Project Snapshot Use Case
Pre-Outage Work Spanning into Outage Use Case
Completed as Scheduled on Day 1 of Outage Use Case
Completed Late on Day 3 of Outage Use Case
Emergent Activity on Day 3 of Outage Use Case
Deleted After Outage Start Use Case
Data Flow from P6 EPPM to P6 Analytics
For More Information
P6 EPPM and P6 Analytics System Architecture Data Sheet
Database Schema and Mappings
Analytics and Reporting Database Field Mapping
Analytics and Reporting Database Schema Documentation
Notices and Disclosures
For More Information