Preparing Primavera Unifier Location Data for Mapping

There are some additional steps required to integrate Primavera Unifier location data with map data. The Primavera Unifier staging tables store columns for State and Country name (for example, United States), however some of the MapViewer layers rely on State and Country code for the mappings. Run the included script at the end of the STARETL process to ensure that the State Code and Country Code columns are populated correctly for use with map data.

To enter location data in Primavera Unifier:

  1. Sign in to Primavera Unifier.
  2. Assign locations to your projects.
  3. From the Company Admin screen, select the Analytics module.
  4. In the Shell mapping configuration, ensure that the Country and State columns are mapped to values that represent country and state codes rather than names.
    • 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 Analytics.
    • If the data type of the UDF is Numeric, then the data will be mapped as a Fact object in 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 of the 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 the Primavera Data Warehouse.


Last Published Friday, July 5, 2024