MAP Viewer Configuration in OBIEE 11.1.1.6.0

Hi All,

There are 3 Parts to this Article

Part 1: Database Setup
Part 2: Map Viewer
Part 3: Answers

Creating Analysis using google Maps click here


I was configuring the MAP viewer in OBIEE 11G last day and as promised here are the detailed step by step details.

MapViewer

MapViewer is shipped as part of Oracle Fusion Middleware. Its main deliverable is a J2EE application that can be deployed to a J2EE container, such as that for Oracle Fusion Middleware. MapViewer includes the following main components:

• A core rendering engine (Java library) named SDOVIS that performs cartographic rendering. A servlet is provided to expose the rendering functions to Web applications.
• A suite of application programming interfaces (APIs) that allow programmable access to MapViewer features. These APIs include XML, Java, PL/SQL, and an AJAX-based JavaScript API.
• A graphical Map builder tool that enables you to create map symbols, define spatial data rendering rules, and create and edit MapViewer objects.
• Oracle Map, which includes map cache and FOI (feature of interest) servers that facilitate the development of interactive geospatial Web applications.
  
  
  
  

Google Maps in OBIEE.

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.

Step 1: 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 here.

Download:

NAVTEQ Data dump 

or from

NAVTEQ Data dump link2 (Download World Sample Navteq Data Bundle 2010)

follow the instructions in the README file 

The main steps in the Read Me file is here

Installing the World Sample Dataset:

===================================

1. Create a work directory on your machine. Change directory to your work 

   directory and download the world_sample.zip file into it. Unzip the 

   world_sample.zip file:

   C:\> mkdir world_sample

   C:\> cd world_sample

   C:\world_sample> unzip world_sample.zip

2. In your work directory, open a Sqlplus session and connect as the SYSTEM 

   user. Create a user for the World Sample data (if you have not previously 

   done so):

   C:\world_sample> sqlplus SYSTEM/password_for_system

Iinstalling the World Sample data

A. Create A tablespace called USERS if it is no there already:

B. Create the world_sample user:

CREATE USER world_sample

IDENTIFIED BY world_sample

DEFAULT TABLESPACE USERS

TEMPORARY TABLESPACE temp

QUOTA UNLIMITED ON USERS;

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

3. 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. 

   This step assumes that you are already connected as the user created in

   the steps above and that you are in your work directory.

   To begin, run the load_sample_data.sql script in your Sqlplus 

   session. Exit the Sqlplus session after the script has successfully 

   concluded:

   SQL> @load_sample_data.sql

   ...

   SQL> exit;

Open the load_sample_data.sql in notepad and check if the file = "filename.dmp" is same in the unziped folder. If not edit the file as below with correct name.

host imp world_sample/world_sample file=world_sample2010.dmp log=world_sample.log full=y

make sure the world_sample schema has loaded successfully .

Now we have to configure the Map Viewer Administration

Find the Steps here

1. Oracle Database
2. OBIEE Server
3. OBIEE RPD
4. OBIEE Maps
5. Weblogic
6. Errors
7. Upgrade
8. Customize
9. Patch

MAP Viewer Configuration in OBIEE 11.1.1.6.0 - Part - 2

Thanks ,

Sandeep

"Thanks to Prasad Madhasi for his article on the same"

SHARE SHARE SHARE

About test