[OBIEE 11g] Map Viewer

MAP VIEWER

Google Maps in OBIEE 11g:

Oracle Maps can be configured now in the map viewer as a built in layer. While using this the tile image for the MAPS will be server from the google maps. After configuring Google Maps, it can be used as a background map in  OBIEE. 

• Installation of navteq mapdata to your oracle database
• Establish a column based relationship between the map and a subject area

Spatial Data:

Maps need Spatial Data coming from a database for the maps to work. This data is provided by NAVTEQ is available for download from this link:    

http://www.oracle.com/technetwork/middleware/mapviewer/downloads/navteq-data-download-168399.html 

   

From this site  we will be download the world_sample.zip file

  

Unzip the    world_sample.zip file:

  

This folder contain below files:

  

 

Installation of navteq mapdata to your oracle database:

Step1: Create a user for world_sample data(if you have not previously done so):

A.     Login to Oracle database and connect as the system user.Create a user for world_sample  data.

B.     CREATE USER world_sample IDENTIFIED BY world_sample

         DEFAULT TABLESPACE USERS EMPORARY TABLESPACE temp

         QUOTA UNLIMITED ON USERS;

         GRANT CONNECT, RESOURCE, CREATE TABLE, DBA TO world_sample;

Step2: This step loads the World Sample data into the specified user, and creates   the metadata required to view the sample data as a Map in MapViewer. 

A.     loads the World Sample data into the specified user:

Login to CMD mode: Start --> RUN -->Type CMD

  

Make sure the world_sample schema has loaded successfully.

After loading we can find out these tables in world_sample user in our database:

Step3: Now download Sample RPD for Mapview and Sample Data for RPD from this url:

https://docs.google.com/file/d/0B9_Go6zX2k0UWG1wdm5VMTFjcjg/edit?pli=1

https://docs.google.com/file/d/0B6im3vPpkba9LUdxRTc5TklRMlU/edit?pli=1

After download we will get the below Rpd and Sample data script for MapBIDemp Rpd :

Rpd password is "Admin12345"

Step4: Configure and load the RPD and database:

             

     A.   Create the mvdemo schema in your Oracle database 

        CREATE USER mvdemo IDENTIFIED BY mvdemo

        DEFAULT TABLESPACE USERS EMPORARY TABLESPACE temp

        QUOTA UNLIMITED ON USERS;

        GRANT CONNECT, RESOURCE, CREATE TABLE, DBA TO mvdemo;

             

     B.    Load the sample date to mvdemo user:

Login to CMD mode and connect to the Oracle database and connect as the mvdemo  user. And the sql script. 

 

 

After running script we can find out these tables in mvdemo user in our database:

Step5: Add your Oracle Database as a MapViewer Data Source:

         

         A.   Login to the Map Viewer Admin console as given below

From

http://localhost:9704/mapviewer/mvlogon.jsp  

or

http://sss11:7001/mapviewer/mvlogon.jsp

B.  Login user your weblogic username/password

C. You should arrive at a home page with a link to view Data sources. Click on Data source  

  

D. Enter the database details as below

E. Click on Refresh button  and Very that the MAP Details has appear in the Console

F. Select "Manage Map Tile Layers"

G. Select Create> Select Google Maps> Continue

 

H. Enter the Details as below

lib_url=http://maps.google.com/maps/api/js?sensor=false

key =not needed (v3)

Enter the details as in the above screen and click submit button on the same page

I. Click on ‘Bring Online’ so that the Map will be available to use in OBIEE Answers

To make sure that the map is created properly  or not ,click on ‘View Maps/ Manage Tiles’ and screen should be looks as follows  and Click on “Show Map “ button.

 

With this step the Map Viewer configuration is complete and now we can start with the configuration in Answers.

Step6: Configuring Map Viewer in Answers

Import a map layer into Answers 

A.           Login to Analysis

B.           Click on Administration –> Manage Map Data –> Layers –> Import Layers

 

C. Select  all , and import all layers as below

D. Screen looks like this 

E. Select  M_STATE_ABRV and click on Edit 

F. Click on and Select Maps Subject Area and Click Ok

G. Click on Background Maps --> Import  Background Maps and select Google Map and click OK

Click On Edit Background Map and Click on to set zoom levels associated with BI Data can display

Select M_STATE_ABRV  from the List and Click OK

I would say select 9 as your zoom level and 2 as default as shown above.

H: Click on images to import all the required images for Google Maps

 

Make sure that you select all from the list and click OK.

With this the configuration of Analytics  is completed

You can now build the analysis and change to view to MAP view and see the maps