The following provides an example of joining the Project State and Country Code data from the Primavera – Activity subject area to the sample NAVTEQ 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 OBIEE_NAVTEQ_Sample.
Select OBIEE_STATE and OBIEE_COUNTRY.
Click OK.
Select OBIEE_STATE and click the Edit layers icon.
In the Edit Layer dialog box:
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 State/Province Code and click Move to move this element to the Selected table.
Click OK to exit all dialog boxes.
Select OBIEE_COUNTRY and click the Edit layers icon.
In the Edit Layers dialog box:
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 Country Code and click Move to move this element to the Selected table.