Beginning with version 16 R1, the Role Utilization subject area is included in Primavera Analytics. The underlying views for this subject did not exist in the P6 EPPM Extended Schema (Px) before P6 EPPM 16 R1. However, if you are using a P6 EPPM 15 R2 database with Primavera Analytics 16 R1, you can manually create the views required for the Role Utilization subject area.
Note: The Role Utilization subject area is not supported with P6 EPPM 15 R1 or lower.
To do this when using P6 EPPM with an Oracle database, complete the following steps:
- Go to <Primavera Analytics unzipped directory>\px_views.
- Open OR_px_role_limit_views.sql in a text editor.
- Log in to the P6 EPPM database instance (using SQL Plus, SQL Developer, or a similar tool) with the P6 EPPM Extended Schema user (for example, PXRPTUSER).
- Run the create view statements in OR_px_role_limit_views.sql to create the two views required to support the Role Utilization subject area (ROLELIMIT and ROLEAVAILABILITY).
To do this when using P6 EPPM with a Microsoft SQL Server database, complete the following steps:
- Go to <Primavera Analytics unzipped directory>\px_views.
- Open SS_px_role_limit_views.sql in a text editor.
- Log in to the P6 EPPM database instance (using SQL Plus, SQL Developer, or a similar tool) with the P6 EPPM Extended Schema user (for example, PXRPTUSER).
- Run the create view statements in SS_px_role_limit_views.sql to create the two views required to support the Role Utilization subject area (ROLELIMIT and ROLEAVAILABILITY).