Configuring MapViewer in OBIEE 11g

Download Navteq spatial SampleApp data from the below link

http://download.oracle.com/technology/products/bi/files/SampleApp_Navteq_dmp.zip

Login to SQL Plus and Create obiee_navteq user to create schema in Oracle Database

Grant permission to obiee_navteq user

Unzip SampleApp and Import into Oracle database(i have unzipped file to C:\)

Open command prompt and execute below command

imp obiee_navteq/obiee_navteq file=C:\obiee_navteq.dmp FULL=Y

Login to SQL Plus and Execute the following insert statements to insert data

Logon to Oracle MapViewer using http://localhost:9704/mapviewer/mvlogon.jsp

Click on “Configuration” to edit mapViewerConfig.xml file

Find “Security Configuration” section and add the below code

<disable_direct_info_request> true </disable_direct_info_request>
<disable_info_request> true </disable_info_request>
<disable_csf>true</disable_csf>
<enforce_security_role> true </enforce_security_role>

In “Security Configuration” section enter the server name

Go to the bottom of mapViewerConfig.xml file and check for “Predefined Data Sources“ section. Add the below code to this section

Keep the exclamation mark (!) before the password. It will encrypt the password next time the MapViewer instance is restarted.

<map_data_source name="obiee_navteq"

                      jdbc_host="localhost"

                      jdbc_sid="orcl"

                      jdbc_port="1521"

                      jdbc_user="obiee_navteq"

                      jdbc_password="!obiee_navteq"

                      jdbc_mode="thin"

                     number_of_mappers="3"

                     allow_jdbc_theme_based_foi="false"

                     editable="false" />

Click on “Save” button to save the changes. Do not click on “Save & Restart”

Restarting the services for these changes to take effect:

Stop Order:
a) BI Components using Oracle Enterprise Manager FMC console
b) The BI Managed Server using the WebLogic console.

Start Order:
a) The BI Managed Server using the WebLogic console.
b) BI Components using Oracle Enterprise Manager FMC console

Start & Stop BI Components Using Oracle Enterprise Manager FMC console

http://localhost:7001/em/

Start & Stop The BI Managed Server Using Oracle WebLogic Admin console

http://localhost:7001/console/

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

Click on data sources, here it will show the data source name which we have created.

Login to obiee console using http://localhost:9704/analytics/

Go to Administration -> Manage Map Data

Here select the Layers and background maps

Successfully Configured MapViewer with OBIEE. Now we can use Maps in Analysis in OBIEE