Before you can generate reports or view data in the Team Usage or Resource Analysis pages, data must be refreshed and calculations must be made in precisely arranged tables and fields. Publication Services address these needs gathering and calculating data as close as possible to real-time. To make this happen, you can configure P6 to automatically publish data to specific tables used for these features. An administrator must configure settings for Publication Services before publishing data. For reports, depending on the type of data published, P6 tables may still be used to generate reports, or a combination of P6 and reporting tables may be used to generate them.
Your organization's P6 EPPM data has two categories: project data and global data. Published project data includes all information about your projects, including summaries, calculations, and auditing data. Published global data includes enterprise data, project, activity, resource, calendar, enterprise data dictionary, security, and auditing data. The Team Usage and Resource Analysis pages use published project data. Reports use published project data and published global data.
To summarize the process:
- Users create new data or make changes to existing data in P6.
- P6 global and project data publishes, automatically or manually.
- Team Usage and Resource Analysis pages draw from the published project data.
- Reports generate directly from the collective P6 EPPM database with the P6 Extended Schema reporting tables.
Note: The BI Publisher sample reports were designed to be run against the small data set included in the sample database. These reports are provided as an example of the product’s capability only. Oracle provides no guarantee, implied or explicit, that the BI Publisher sample reports will run against your database or will produce meaningful data when they are run against your database. You may modify the BI Publisher sample reports to suit your own data set, including adding filter criteria to limit data output or changing filter criteria to suit your data. You need a full BI license to modify sample reports.