Business Intelligence – Oracle

Oracle BI EE and Mapviewer – Step by Step integration – Phase1

Posted by Venkatakrishnan J on September 25, 2007

Update: Phase2 and Phase3 are available here

I had mentioned in my previous blog entry here that i was working on documenting a step by step approach for the integration between Mapviewer and BI EE. Well, the integration is not pretty much out of the box and involves quite a bit of understanding primarily from the Mapviewer front. So, just be aware that the integration is not out of the box and would require some amount of coding. The entire integration process involves understanding 3 major pieces.

1. Understanding how to pass parameters between Mapviewer and a Dashboard Prompt (Maps must change as we change the prompt).

2. Understanding how we can simulate drill down within a map (This is the harder part that does not involve BI EE).

3. Understanding how one can change the prompts of BI EE as we navigate in a Map.

We will see the first part today as part of a 3-phase series wherein i would try to document this in a step by step fashion. But before i go there, one would have to have these pre-requisites done.

1. Deploy Mapviewer in the OC4J that holds BI EE.

2. Get all the demo setup of Mapviewer up and running. One must be able to view the demo maps that comes along with mapviewer.(This needs a schema called mvdemo that would basically contain all the spatial data in an Oracle Database).

3. A little background of javascript is desired.

If you have all of these pre-requisites then you can try the following. We would be seeing the phase 1 of the integration process. The idea of this integration is to create a dashboard prompt that would basically contain all the cities and based on the city that we select, we must get a map which would show all the customers within that city.

This involves the following steps.

1. Import the table called customers(without the location column) into OBI EE Administration Console. Do the corresponding mapping in BM and the Physical layer.

2. Once this is done. We would have to create a dashboard prompt that would basically list down all the cities and also set a presentation variable called Region based on what we have selected.

As you see above, i have created a dashboard prompt that would basically set a presentation variable called Region.

3. Now lets go to the mapviewer and open up the default demo map called “Array Parameter and Templated Theme Based FOI”.

The map should look like this.

Our idea is to build upon an existing map. The above map basically varies the map based on input city names.

Now lets view the source of the above map and change the source based on our requirements. I have used the following code wherein i have removed unnecessary parts. Remember we would be passing the presentation variable as the URL parameter to the mapviewer. I have added a function called getURLParameter which would basically store the value of the URL parameter in a variable called Region.

Test out whether the URL parameter is getting passed properly to mapviewer. The URL to pass into the mapviewer would look like this http://localhost:9704/mapviewer/fsmc/tutorial/samples/DynarrayThemeBasedFOI.html?Region=OAKLAND

4. The next step is to pass down this Region variable to the mapviewer from the dashboard prompt. We can do that using iframes in a narrative view report. Create a new narrative view report and enter the data as shown below. The iframe URL would be like this{Region} where @{Region} is the presentation variable that we had created in step 2.

5. Once this is done, we would have to call the both the reports from a dashboard i.e the Dashboard Prompt report and Narrative report.

I will follow this one up with phase-2 and phase-3 later. But the above should get you started.

24 Responses to “Oracle BI EE and Mapviewer – Step by Step integration – Phase1”

  1. Fiston said

    Thanks, great work! Looking forward to phase-2 and phase-3

  2. Mike said

    Thanks for this, I’ll have a look into it. A bit disappointed that there’s such a big gap between the announcement of ‘oob’ and the actual ‘we do support it’ 😉

  3. […] Posts Oracle BI EE and Mapviewer – Step by Step integration – Phase1Oracle 11g – PIVOT and UNPIVOTCustomizing OBI EE – GO URL ParametersOracle 10g/11g – OLAP, CUBE […]

  4. […] and SkinsOracle BI EE – Write Back Option – Budgeting/PlanningOBI EE and VPDOracle BI EE and Mapviewer – Step by Step integration – Phase1BI Publisher and VPDCustomizing OBI EE – SOAP APIAbout […]

  5. Tina said

    Can you share the source code of mapParameter.html?
    Sorry not very familiar with JS 😦


  6. Tina said

    Got it :). The url is available for me.


  7. Vinayak said

    Hi Venkata,

    I was trying to deploy mapviewer on my server.
    According to the documentation I got from the oracle site, I have to create a schema mvdemo in oracle.
    Then I have to upload data using the oracle dump and populate the data using mvdemo.sql. The sqls in this file refer to a schema MDSYS. They refer to tables and synonyms.
    I have no idea as to how the schema is got .. Please help me in this.


  8. Chandra said

    Hi Venkat,

    We want to compare some exclusive features of Oracle BI EE over other BI tools in market like Hyperion IR and I think this example would be a step in that direction.

    So I need to install Mapviewer *.ear server file,correct me if I am wrong.


  9. solap said

    Spatial OLAP will explode in the coming years.

  10. Anil said

    Hi Venkat,

    Can u share the The text u have written inside the narrative view?
    Actually I am very new to OBI EE and couldn’t get the things clear about narrative view and presentation variable.


  11. David said

    Hi Venkata,

    Could please share the code you use in the mapParam.html file?

    Thanks in advance!

  12. Greg said

    I’ve tried to do these steps, but the map doesn’t seem to changed based on the variable. I think it may be because Map Viewer is not deployed in the OBIEE OC4J container. Thing is, I’m terrible at Java. How would I go about doing this? I understand it has to do with the .ear file, but that’s about all I know. Any advice is appreciated.

  13. Samo said

    Hi Vanky,
    please, share the code for this phase and phase 2 and 3. I am having Mapviewer up and working, I created html with the embeded java script, but it keeps rendering the same map – it does not react on the parameter sent.

  14. Prakash said

    Hi Venkatakrishnan ,
    !! Great stuff !!..but it still not clear to me can you provide us the script u wrote for this as it not clear with the screen shots.

    Thanks & Regards,

  15. I said

    Venkat, Many thanks for providing the information I have been searching frantically for. I have created the dashboard prompt and narrative views separately as you suggested, but the value selected in the prompt is not being passed to the narrative view. Anything you notice that I may have missed? (FYI, I am not integrating with Mapviewer but with a different website).

    Can you post a screenshot of your “Edit Dashboard” screen as that is the only area where I see the possibility of some error in my case?

  16. SR said

    Hi Venkat,

    Great BLog on mapviewer. Anychnce you could put a detail step by step description of the prerequestie steps as well, which would help new learners like me.


  17. Bharath Kumar said

    Hello venkata,
    I am a beginner in OBIEE. I want to know the installation and configuration of OBIEE to connect to my oracle server and then extract data from that and create reports! Could you please help me in this regard.

    Thanks in advance…


  18. Sudheer said

    Would like see that JS …Please send it to me. Thanks in Advance

  19. Mike said

    This was really good

  20. jayeeta123 said

    Hi Venkat,

    Can you please provide the html code.


  21. […] В последнее время тема интеграции Oracle BI и Mapviewer стала очень популярная. К сожалению, на русском языке информации крайне мало. В этой статье я постараюсь закрыть эту проблему. За основу взята статья Venkatakrishnan J, Oracle BI EE and Mapviewer – Step by Step integration, которую можно найти по адресу…. […]

  22. Devang said

    Hi Venkat,

    Can you please share MapParameter.html file?


  23. vj said

    Incorrect Step 2 Snapshot: Do the corresponding mapping in BM and the Physical layer.

    The uploaded snapshot for step2 is depicting Mapping between Employees and Departments.

    Can you update this snapshot. Just wanted to know how to bifurcate Customer Dimension and Sales Fact from single physical table.


  24. mostplast said

    реализация плиты дорожные б/у, ПДП, ПДН 2ПД 30-18-30, Плиты забора ОП-2 ОП-2-1/фартук/ Элементы инж. сетей Л-11-8/2 Л-20-11/2, ПАГ18Y-B-CA, детали на

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: