P6 EPPM supports the ability to enter location data at the dictionary level that can be assigned to Projects, Activity, and Resources and then extracted, transformed, and loaded into Primavera Data Warehouse for use in Oracle Business Intelligence (OBI) analysis.
To create location data in P6 EPPM, complete the following steps:
- Sign in to P6 EPPM with an account that has the privilege to change enterprise data (for example, admin).
- From the Administer
menu, select Enterprise Data. - In the Enterprise Data pane, expand Global and select Locations.
- Enter the location data as appropriate for your specific needs.
- Assign locations data to projects, activities, and resources as needed.
Note: See the P6 help for information about entering and assigning location data.
- After all of the location data is entered and assigned where appropriate for your environment, run all of the Global Publication Services to ensure that the data in the publication tables is up to date. After Publication Services have run to successful completion, run the STARETL process to extract, transform, and load the data from P6 EPPM to Primavera Data Warehouse. See the Primavera Data Warehouse Installation and Configuration Guide for details.