- Log into OBI with an account that has a BI Administrator role.
- Select Administration.
- Under Map Data Management, click Manage Map Data.
- In the Manage Map Data page select the Layers tab.
- Select COUNTRIES_ALL_LABEL_CLEAR and click the Edit layers icon.
- In the Edit Layer dialog box, in the Name field, select ALL COUNTRIES.
- Add the Project-Location BI Key for the Primavera - Activity subject area:
- In the BI Key Columns section, click +.
- In the Select Subject Areas list, select Primavera – Activity.
- In the Select BI Key Columns dialog box, expand Project, then Location.
- Select the Country Name and select Move.
- Click OK.
- Add the Activity-Location BI Key for the Primavera - Activity subject area:
- In the BI Key Columns section, click +.
- In the Select Subject Areas list, select Primavera – Activity.
- In the Select BI Key Columns dialog box, expand Activity, then Location.
- Click the Country Name and select Move.
- Click OK.
- Add the Resource-Location BI Key for the Primavera - Activity subject area:
- In the BI Key Columns section, click +.
- In the Select Subject Areas list, select Primavera – Activity.
- In the Select BI Key Columns dialog box, expand Resource, then Location.
- Click the Country Name and select Move.
- Click OK.
- Add the Project Location BI Key for the Primavera - Project History subject area:
- In the BI Key Columns section, click +.
- In the Select Subject Areas list, select Primavera – Project History.
- In the Select BI Key Columns dialog box, expand Project, then Location.
- Click the Country Name and select Move.
- Click OK.
- Select US_STATES_BI and click the Edit layers icon.
- In the Edit Layer dialog box:
- In the Name field, select US STATES.
- Use the same steps you used to create ALL COUNTRIES, but choose STATE CODE instead of Country Name for each step.
- Repeat these steps as needed for each Subject Area for which you want to display location data on a map.
Sample of Joining Primavera Data Warehouse Data and MVDEMO Data