The following provides an example of joining the Project State and Country Code data from the Primavera – Activity subject area to the sample MVDEMO data:
Log into OBI with an account that has a BI Administrators role.
Click the Administration link at the top of your screen.
Under Map Data Management, click Manage Map Data.
In the Manage Map Data page:
Click the Layers tab.
Click the Import Layers icon.
In the Import Layers dialog box:
In the Look in field, select mvdemo.
Select CITIES_ALL, COUNTRIES_ALL_LABEL_CLEAR, and US_STATES_BI.
Click OK.
Select CITIES_ALL and click the Edit layers icon.
In the Edit Layer dialog box:
In the Name field, change CITIES_ALL to ALL CITIES.
Add the Project-Location-City Name option:
In the BI Key Columns section, click the + icon.
In the Select Subject Areas pop-up, select the Primavera – Activity subject area.
In the Select BI Key Columns dialog box, expand the Project folder, then expand the Location folder.
Click the City Name and click Move to move this element to the Selected table.
Click OK.
Add the Activity-Location-City Name option:
In the BI Key Columns section, click the + icon.
In the Select Subject Areas pop-up, select the Primavera – Activity subject area.
In the Select BI Key Columns dialog box, expand the Activity folder, then expand the Location folder.
Click the City Name and click Move to move this element to the Selected table.
Click OK.
Add the Resource-Location-City Name option:
In the BI Key Columns section, click the + icon.
In the Select Subject Areas pop-up, select the Primavera – Activity subject area.
In the Select BI Key Columns dialog box, expand the Resource folder, then expand the Location folder.
Click the City Name and click Move to move this element to the Selected table.
Click OK.
Add the Project History-Location-City Name option:
In the BI Key Columns section, click the + icon.
In the Select Subject Areas pop-up, select the Primavera – Project History subject area.
In the Select BI Key Columns dialog box, expand the Project folder, then expand the Location folder.
Click the City Name and click Move to move this element to the Selected table.
Click OK.
Select COUNTRIES_ALL_LABEL_CLEAR and click the Edit layers icon.
In the Edit Layer dialog box:
In the Name field, change COUNTRIES_ALL_LABEL_CLEAR to ALL COUNTRIES.
Use the same steps you used to create ALL CITIES, but choose Country Name instead of City Name for each step.
Select US_STATES_BI and click the Edit layers icon.
In the Edit Layer dialog box:
In the Name field, change US_STATES_BI to US STATES.
Use the same steps you used to create ALL CITIES, but choose STATE CODE instead of City Name for each step.