To extract and load a subset of P6 EPPM Codes to Primavera Data Warehouse:
- Sign in to Primavera Analytics Administration Application:
http://<host>:<port>/p6rdb
- In the left pane, select Status
.
- In the All list, select staretl<id> or a <Custom Name for data source>.
- In the left pane, select Codes
.
- Select any of the following tabs to extract and load the following P6 EPPM codes to Primavera Data Warehouse:
- Project
- Activity
- Resource
Note: Primavera Data Warehouse has a limit of 240 codes for each supported type (project, activity, and resource). By default, Primavera Analytics exposes only the codes that have been enabled through the File System-based Configuration utility or Primavera Analytics Administration Application.
- To select a code to be loaded to Primavera Data Warehouse:
- In the Available Codes list, select a code.
- Select the right-arrow
to move the selected code to the Enabled Codes list.
- Use the up and down arrow buttons to change the order of the codes in the ID column.
- Select Save Changes.
Note: On the Activity tab, configure the scope each Activity code in the Enabled Codes list from the following levels in Primavera Data Warehouse: Global, EPS, and Project. If the same code name is mapped at different levels (Global, EPS, and Project), then use the Scope column to determine at which level an activity code exists. For example, if you have a global activity code called MyCode, and a project activity code called MyCode, then use the Scope column to determine which activity code value to use.
- To deselect a code:
- In the Enabled Codes list, select a code.
- Select the left-arrow
to move the selected code to the Available Codes list.
- Select Save Changes.
Note: The Primavera Analytics Administration Application cannot configure codes for a Primavera Unifier data source. Primavera Unifier code configuration must be done within Primavera Unifier interface. For more details, see <ProdName_Unifier> documentation.
Additional Information on Codes
All codes configured in the Primavera Analytics Administration Application 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 only 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.