New P6 Reporting Database R2
- by mark.kromer
Along with our announced GA release of P6 Analytics R1 recently, you may have noticed that when you purchase P6 Analytics, we provide a restricted use license for P6 Reporting Database R2. This represent an updated version of the previous P6 Reporting Database 6.2 and can be purchased individually on a per-CPU basis. Typically, you will want just the reporting database if you would like the P6 data warehouse components such as the ETL, data models, ODS and star schemas in order to report on that data with another reporting tool other than Oracle.
The P6 Analytics solution will only work on Oracle BI (OBI). But I pasted below some examples of a simplistic matrix report that I built from the P6 Reporting Database using Microsoft SQL Server Reporting Services. This is the Report Builder tool which is very similar to other similar tools to build reports on the market today such as Crystal Reports or Oracle BI Publisher. This is an example of what you can do (in a very simple format) by using the P6 Reporting Database without P6 Analytics:
Here is a quick run-down of some of the key new features in P6 Reporting Database R2 that were added as enhancements to the 6.2 version:
• 4 new star schemas (improved projects star, project history, resource utilization and resource allocation)
• Improved ETL performance and reliability
• P6 security is inherited at the star schema level
• Custom P6 project, activity & resource codes are now available as customizable dimensions in the star schemas
• Time-phase data down to the data is now available from the star schemas
• An updated Operational Data Store (ODS) for operational reporting that includes the WBS hierarchy
• The ODS now includes daily spreads for activity and resource assignments