P6 Reporting Database works with the P6 EPPM database to provide a robust and powerful reporting solution. P6 Reporting Database consists of the Star and ODS databases.
The Star Database
The Star database enables an organization to perform advanced business analysis on project and portfolio data. It supplies a dimensional schema that organizes P6 EPPM hierarchical relationships. The Star schema allows organizations to store data for History Levels (Project, WBS, Activity, or Assignment) for a specific History Interval (Year, Quarter, Financial Period, Month, Week, or Day). This data allows for tracking trends for advanced business intelligence. The Star database captures data for activities, resource assignments and utilization, and user defined fields. P6 Analytics requires the Star database.
The Operational Data Store (ODS)
The ODS portion of P6 Reporting Database is an optional relational database that supplies day-to-day, easy to understand operational views of the P6 EPPM database data. You can also use the P6 Extended Schema to provide this information.
In This Section |
Legal Notices
Copyright © 1999, 2014,
Oracle and/or its affiliates. All rights reserved.
Last Published Friday, January 31, 2014