Depending on your organization's specific deployment, P6 EPPM, P6 Reporting Database, and P6 Analytics work together as depicted below.
Applications:
P6 EPPM: P6 EPPM is the primary interface for administering and managing projects. This is where you will gather the data on which P6 Analytics will report. P6 EPPM provides an extensive array of features designed to optimize all phases of Project Management, Resource Management, and Portfolio Management. It includes full support for activities, work breakdown structures, planning and scheduling, costs, resource administration and assignment, codes, user defined fields, roles, teams, and capacity planning.
Oracle Business Intelligence (OBI): OBI integrates data from multiple enterprise sources, and transforms it into key insights that enable strategic decision-making, drive continual business process improvements, and promote alignment across the enterprise. OBI can also generate proactive alerts based on integrated reports data mined from P6 Reporting Database.
Oracle BI Publisher: Oracle Business Intelligence Publisher is an enterprise reporting solution allowing you to design, manage, and deliver highly formatted documents. Because it is built on open standards, your IT developers can create data models against practically any data source and use BI Publisher APIs to build custom applications leveraging existing data sources and infrastructure. BI Publisher users can design report layouts using familiar desktop tools, reducing the time and cost needed to develop and maintain reports. Extremely efficient and highly scalable, BI Publisher can generate documents with minimal impact to transactional systems.
P6 Analytics: This integrated dynamic reporting tool, uses the data gathered in P6 and the OBI metadata layer, to facilitate the creation of ad hoc reports and interactive custom dashboards reflecting trends and metrics for activities, portfolios, resource assignments, utilization, and project history.
Technology:
The P6 EPPM Database: The main database for P6 EPPM data. The EPPM database includes the P6 Extended Schema (Px) optimized for reporting.
The Reporting Database: The P6 Reporting Database consists of the Star database and the Operational Data Store (ODS) database. Each of these pulls data from the P6 EPPM Extended Schema, which can then be used to create reports. The Star database accumulates project data over time, providing baselines for tracking trends and for advanced business intelligence; it also provides key metrics on current data, which allows you to drill through root cause analysis. Users can view the data by using OBI. The ODS database gives users the option to access denormalized, relational views of P6 EPPM data by using tools such as Oracle Business Intelligence Publisher.
In This Section |
Legal Notices
Copyright © 1999, 2014,
Oracle and/or its affiliates. All rights reserved.
Last Published Friday, January 31, 2014