Sample of Joining P6 Data and NAVTEQ Data

Previous TopicNext TopicContents

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:

  1. Log into OBI with an account that has a BI Administrators role.
  2. Click the Administration link at the top of your screen.
  3. Under Map Data Management, click Manage Map Data.
  4. In the Manage Map Data page:
    1. Click the Layers tab.
    2. Click the Import Layers icon.
  5. In the Import Layers dialog box:
    1. In the Look in field, select OBIEE_NAVTEQ_Sample.
    2. Select OBIEE_STATE and OBIEE_COUNTRY.
    3. Click OK.
  6. Select OBIEE_STATE and click the Edit layers icon.
  7. In the Edit Layer dialog box:
    1. In the BI Key Columns section, click the + icon.
    2. In the Select Subject Areas pop-up, select the Primavera – Activity subject area.
  8. In the Select BI Key Columns dialog box:
    1. Expand the Project folder, then expand the Location folder.
    2. Click the State/Province Code and click Move to move this element to the Selected table.
    3. Click OK to exit all dialog boxes.
  9. Select OBIEE_COUNTRY and click the Edit layers icon.
  10. In the Edit Layers dialog box:
    1. In the BI Key Columns section, click the + icon.
    2. In the Select Subject Areas pop-up, select the Primavera – Activity subject area.
  11. In the Select BI Key Columns dialog box:
    1. Expand the Project folder, then expand the Location folder.
    2. Click the Country Code and click Move to move this element to the Selected table.
    3. Click OK.

Related Topics

Installing and Configuring OBI 11g NAVTEQ Sample Spatial Data

Configure Background Maps

Adding Maps to Analysis



Legal Notices
Copyright © 1999, 2014, Oracle and/or its affiliates. All rights reserved.

Last Published Friday, January 31, 2014