Oracle BI EE 11g – Map Views – Integration with Mapviewer

August 19th, 2010 by

One of the biggest new features in BI EE 11g is the ability to create native mapviewer maps and then overlay reporting components/visualizations on top of maps. For example if you are doing a country based sales analysis, its easy to color code each country across the world right within the maps. It is also possible to overlay pie charts, bar charts in the maps thereby providing an extensive visual analysis capability. In 10g, one had to go through some complex java scripting to achieve BI EE and mapviewer integration. I have blogged about it here and here. 11g makes this entire integration a lot easier.

Lets try to understand the integration through a simple example. Shown below is a report of Sales performance of 3 US states across 4 years.

We would like to depict this using a map as shown below.

As you see we have 2 visualizations applied on the same map. The first one is a different color coding for each of the 3 states depending on the sales performance. The other is a pivot representation of yearly performance for each state, all within a single map.

To do this we start with enabling the Mapviewer integration by updating the instanceconfig.xml to include the following tags (in each presentation server)

<SpatialMaps>
<ColocatedOracleMapViewerContextPath>/mapviewer</ColocatedOracleMapViewerContextPath>
<RemoteOracleMapViewerAbsoluteURL></RemoteOracleMapViewerAbsoluteURL> <LayerDataLayout>
<MaxRecords>600</MaxRecords>
</LayerDataLayout>
</SpatialMaps>

Then we need to restart the presentation service. This enables the connectivity between BI EE and Mapviewer. After enabling the integration, we then import the standard spatial MVDemo schema into the Oracle Database. This schema contains Layers, Themes and some Base maps for all the major US States, Cities & some inter-state highways. After importing and installing the MVDemo schema, we need to download the Mapbuilder application which will enable us to create a custom map. We will be using this map for rendering in BI EE. The Mapbuilder application can be downloaded from here.

After downloading the Mapbuilder app, we start the application and login to the MVDemo schema. By default this schema contains a lot of built-in themes, Base Maps and Tile Layers.

We start off with creating a simple Base Map called STATE_MAP which will be using 2 out of the box themes THEME_DEMO_STATES and THEME_DEMO_STATES_LINE

This step will enable us to render all the US States and its boundaries within a very simple map as shown below

Once the base map is created, lets create a new tile layer called STATE_TILE_MAP which will use this base map for rendering. We can define all the zoom levels, boundaries etc within the tile layer

Now we have a map that can show all the US states and its boundaries. We need to now expose this map to the mapviewer application (as an admin user through Mapviewer admin screen) by taking it online as shown below

Now the map is available for consumption through BI EE. Remember, the theme that we used above, THEME_DEMO_STATES has an identifier called STATE_ABBR which is basically the key that we need to pass from BI EE. Relationship between BI EE repository columns/subject areas and Mapviewer maps are done from the Manage Map Data screen in the presentation services admin console.

In this screen, we need to import the layers, maps and the images that we want to include as shown below

Edit the THEME_DEMO_STATES theme and map the State column from the repository. There need not be any relation between the column used in spatial and the column mapped in BI EE. All we need to ensure is the attributes should match. In my case, the State abbreviations come from the SH schema and the THEME_DEMO_STATES come from STATES table in the MVDemo schema.

Then navigate to the STATE_TILE_MAP in the background maps and add the THEME_DEMO_STATES again.

This establishes a relationship between the Subject Area and the Map thereby enabling us to add the mapview from answers. After doing this, lets create the report from the SH schema containing just the 3 states for 4 years.

Use the new Map View option to create the map.

This will render the map that we created in mapviewer. If you notice carefully, it will automatically apply some color coding to the 3 states that are part of the report.

The color coding is actually part of default visualization that Map Views apply on a map. Lets change this to something as shown below

Lets now create one more pie chart visualization (for obtaining the yearly breakup of sales in all the 3 states)

Lets use the Year as the column providing the necessary slices for the pie charts

This will give us the necessary visualization using Mapviewer.

Though there are a lot of steps involved, majority of the steps are for setting up the mapviewer. Once we have the maps set up the entire process of adding visualization to maps is quite straight forward.


Comments

  1. Deepak Says:

    How to pass prompts in map, as in 10g we can pass prompt value via presentation variable and used that in java script code. How to achieve that in new version.

  2. Deepak Says:

    How to pass prompts to a map.

  3. Alex Says:

    I tried to change the file instanceconfig.xml inserting the tag <SpatialMaps …. mannually. Then, my presentation process didn´t more restart. You know if is there another way to change or solve this problem.
    (error: operation failed: start; oracleinstante: instance1; component: coreapplication_obips1

  4. Kamran Ali Says:

    Hi,

    How this Map can be develop as interative as it works like Master in Master-Detail functionality.

    Regards,
    Kamran

  5. Raghu Narayana Says:

    I downladed Mvdemo schema it is a oracle database. How can i bring that into my local sql server? I followed the steps given in readme text file, i was not able to get that. Is there any alternative solution.. Can any one suggest please…

    Regards,
    Raghu N

  6. Mark Rittman Says:

    Raghu, I believe this feature (Oracle Mapviewer) relies on Oracle Database spatial features, and as such doesn’t work with MS SQL Server. You’ll need to load up the data in an Oracle database to get it working.

  7. Raghu Narayana Says:

    Mark,
    Thanks for your fast replay. I am very new to OBIEE11g, it says that maps is a new features added here. But when i try to view the results using a map view i get an error like “base map required to render a map”. Can i get any sample SQL database through which i can render map into dashobards?…

  8. Lucas Rehem Says:

    Hi Mark,

    Congratulations for your work!I’m a brazilian and your advices really helped me!

    Ty,

    Lucas R. A.

  9. Sujana Says:

    Any idea how to fetch the answers xml response url in 11g ?

  10. Vinay Says:

    Any ideas or suggestions to incorporate world maps?

  11. Sudhakar Says:

    Hi all,
    I downloaded mvdemo schema after that am trying to create base maps but i am not getting so can u please suggest any one.

  12. Cell Says:

    Can we integrate it with map built from scratch (arc view, map object,autocad) etc?

Website Design & Build: tymedia.co.uk