Project, Activity, and Resource codes can be extracted from P6 EPPM and loaded into Primavera Data Warehouse.
To configure P6 EPPM codes for Primavera Data Warehouse:
- In the Codes screen, select a code as follows:
- In the Available list box, select the code you want to extract.
The list of available codes will be populated based on the P6 EPPM database connection that you set up in the previous screen for an Oracle database.
- Click the > right-arrow button to move the code to the Selected list box on the right.
If this is the first time that you are running the configuration utility, the Selected list box is initially empty.
- In the Available list box, select the code you want to extract.
- To deselect codes:
- In the Selected list box, select the code you want to remove.
- Click the < left-arrow button to move the code to the Available list box on the left.
- Repeat the above steps for each code you want to extract or remove to finalize the list of codes.
Primavera Data Warehouse has a limit of 240 codes for each supported type (Project, Activity, and Resource).
- Click Next after selecting all the required codes.
See Configuring P6 EPPM User-Defined Fields for Primavera Data Warehouse to continue the configuration process.
Additional Information on Codes
- The Selected list box contains two additional columns:
- The Scope column determines the activity code to use if the same activity code name is mapped at different levels (Global, EPS, and Project). For example, if you have a global activity code called MyCode, and a project activity code called MyCode, the scope setting would determine which activity code value to use.
- The ID column determines the placement of the selected code type (Project, Activity and Resource) within the Primavera Data Warehouse code table.
- Where applicable, all codes configured in the configuration utility are available as hierarchies in Primavera Data Warehouse. Full path values or specific node level values are available for each code. Code Hierarchies apply to Project, Activity (Global only), and Resource codes. Hierarchies do not apply to Activity codes in Project or EPS codes. There are no additional configuration steps required to use code hierarchies.
- Secure codes are not currently supported by Primavera Data Warehouse.
- If you need to add additional codes, you can run the configuration utility at any time.
- Primavera Analytics imposes an upper limit of 100 UDFs for type (Text, Date, Integer, Cost) and subject area (Activity, Project, Resource, Resource Assignment, WBS), with the exception of Indicator type UDFs, which have a limit of 20. Codes are limited to 200 for each subject area (Activity, Project, Resource). If you need to exceed these limits, you must configure the .rpd file accordingly. For details, see https://blogs.oracle.com/P6Analytics/entry/how_to_add_more_than.