Primavera Unifier supports the ability to enter location data that be assigned to project shells and then extracted, transformed, and loaded into Primavera Data Warehouse for use in Oracle Business Intelligence (OBI) analysis.
To enter location data in Primavera Unifier:
- Sign in to Primavera Unifier.
- Assign locations to your projects.
- From the Company Admin screen, select the Analytics module.
- In the Shell mapping configuration, ensure that the State, State Code, Country, and Country Code columns are mapped to the appropriate Primavera Unifier data elements.
- Note: When you map a Shell to a UDF in the Unifier Analytics module, the data type of the UDF determines whether it will be available as a dimension or a fact in in analytics.
- If the data type of the UDF is String or Date, the data will be mapped as a Dimension object in Primavera Analytics.
- If the data type of the UDF is Numeric, then the data will be mapped as a Fact object in Primavera Analytics, and is only available in the Primavera - Project User Defined Fields and Primavera - Project User Defined Fields History subject areas.
After you have entered and assigned all of the location data where appropriate for your environment, run all Publication Services to ensure that the data in the publication tables is current. After Publication Services have run successfully, run the STARETL process to extract, transform, and load the data from Primavera Unifier to Primavera Data Warehouse.