Tuesday, January 8, 2013

[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:    

   



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:


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


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






2 comments:

  1. I am using OBIEE 12C MAP VIEWERE and I followed your map viewer blog. I successfully configured .xml file. But Bring Online and Take Offline feature is not active in Manage Tile Layer. Please can help me where I did wrong.

    Thanks in Advance
    Sadashiv

    ReplyDelete
  2. This comment has been removed by the author.

    ReplyDelete