Product Description
Oracle’s Primavera P6 Reporting Database is a data warehouse product that is optimized for enterprise deployments of Primavera P6 Enterprise Project Portfolio Management. The Primavera P6 Reporting Database provides a central repository for all portfolio, project and resource data. Its open architecture allows users to create their own custom operational reports and business intelligence analysis using any third-party reporting tools. While native analytical tools are provided in Primavera P6 Enterprise Project Portfolio Management and Primavera P6 Professional Project Management, this reporting database option allows more flexibility in creating custom reports for executive management and the project team.
Features
- Operational data store for operational reporting
- 4 star schemas in project, resource & history subject areas
- Prebuilt ETL process to persist virtual data
- Operational views
- Business intelligence trending views
- Compatible with Oracle BI and 3rd party reporting and business intelligence tools
- Scheduled data refresh
- Role-based security
Benefits
- Optimize performance by creating reports using an operational data store and not the transactional project management database
- Discover hidden trends by enabling business users to easily analyze project data
- Access calculated data such as performance metrics, variances, and earned value, indexes
- Perform advanced business analytics on project and portfolio data
- Reduce compliance costs by providing auditors with snapshots of data at any given time
Screenshots
|
