Business Intelligence – Oracle

Archive for the ‘Mapviewer’ Category

Oracle BI EE 10.1.3.3/2 – Audio, Video and Maps

Posted by Venkatakrishnan J on October 25, 2007

I came across a very interesting piece of video wherein interaction between Maps and OBI EE was shown. I am not sure what Map is being used here(i think it is Google Maps or Mapviewer. Not sure exactly). But a wonderful video neverthless.

Now the next question is how do we embed this video in BI EE. It is pretty straight forward. Open a report. Add any dummy coumn and hide the column. Now go into Static Text view. Put the embed object into the Static Text view. Also, enable the HTML Markup check box. Now you should be able to see the video.

      

The same applies for audio too. So, in effect you can listen to content specific songs while viewing the reports :-).

Posted in All Posts, Mapviewer, OBI EE Plus | 9 Comments »

Oracle BI EE 10.1.3.3 and mapviewer – Step by Step Integration Phase2 / Phase3

Posted by Venkatakrishnan J on September 26, 2007

We saw yesterday here on how to go about implementing the phase 1 of integrating OBI EE and Mapviewer. Now lets discuss the next 2 phases. I would rather focus on the phase 3 which shows how to about passing parameters from Mapviewer to OBI EE.

Phase 2 is primarily on the mapviewer front wherein one can have multiple basemaps and change the basemaps when we click on any foi region dynamically in order to simulate a drill down. We would be using the same example as we used in phase1. But our aim is to showcase the way of passing parameters from mapviewer to OBI EE. So, lets begin with the simple map that we created yesterday. Instead of passing parameters to the map, we would change the map in such a way that it would show the customers in 2 cities i.e OAKLAND and HAYWARD. The idea is to show the sales of a city while clicking on any customer within that city. For example, if we click on any customer within OAKLAND our OBI EE sales report should change and show the sales of OAKLAND. The same should happen for HAYWARD city.

1. Lets create a BI EE report that would basically show the sales of all the cities. Create a filter on city that would be entered via prompts (i.e prompted).

      

      

2. Once this is done, the next step is to create a narrative BI EE report that would basically call the above report using iframes. Ensure that iframe is given a name and also check the GO URL parameter for the BI EE report that we created earlier. It should look like this

http://localhost:9704/analytics/saw.dll?GO&NQUser=Administrator&NQPassword=Administrator&Path=/shared/Paint+Demo/Mapviewer/City+Sales&Options=md&Action=Navigate&P0=1&P1=eq&P2=”Dimension%20-%20Customer”.CITY&P3=”OAKLAND”

The above url will pass OAKLAND as a parameter to the BI EE report which in turn would be displayed in a narrative iframe element named BI EE.

      

3. The next step is to create a map that would basically show the customers within the 2 cities OAKLAND and HAYWARD. We shall use the same map that we created yesterday. Save the same map as a new map and modify it to suit our needs.

      

Lets discuss the structure of the map html today. I have commented out the part wherein we had passed Region as a parameter to the map yesterday. Also, i have hardcoded 2 regions OAKLAND and HAYWARD using the below parameter variable.

var parameters = “\”” + “OAKLAND” + “\”,” + “\”” + “HAYWARD” + “\””;

Once this is done, we need to add a listener in order to make the map listen for mouse clicks on the customers. This is done by this part of the code.

var marrayPara = new ArrayParameter(parameters,’sarray’,’city_list’);
var themebasedfoi=mapview.getThemeBasedFOI(“themebasedfoi1”);
if (themebasedfoi==null)
{
themebasedfoi = new MVThemeBasedFOI(‘themebasedfoi1′,’mvdemo.customer_by_cities’);
themebasedfoi.setQueryParameters(marrayPara);
themebasedfoi.setBringToTopOnMouseOver(true);
mapview.addThemeBasedFOI(themebasedfoi);
}
else
{
themebasedfoi.setQueryParameters(marrayPara);
themebasedfoi.setBringToTopOnMouseOver(true);
themebasedfoi.refresh() ;
}

themebasedfoi.addEventListener(“mouse_click”, foiClick);
}

After adding the mouse click event, we need to define the foiClick function that would basically obtain the city name (stored in the foi) and pass it on to OBI EE.

function foiClick(point, foi)
{

var drillURL =
http://vejanaki-pc:9704/analytics/saw.dll?

GO&NQUser=Administrator&NQPassword=Administrator&Path=/shared/Paint+Demo/Mapviewer/City+Sales&Options=md&Action=Navigate&P0=1&P1=eq&P2=\”Dimension%20-%

20Customer\”.CITY&P3=”+foi.attrs[1];

objWin = window.open(drillURL, “biee”,”height=480,width=240,scrollbars=yes,resizeable=yes”);

}

The foi.attrs[1] would have the city name and this is passed to OBI EE in the form of GO URL parameter. OBI EE report would change dynamically since window.open points to the biee (name we gave earlier to the iframe) iframe.

      

When one clicks on the OAKLAND customers, the OBI EE report would give the sales of OAKLAND city. Same is the case for HAYWARD.

      

      

Posted in All Posts, Mapviewer, OBI EE Plus | 9 Comments »

Oracle BI EE 10.1.3.3 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 http://10.176.246.99:9704/mapviewer/fsmc/tutorial/samples/mapParameter.html?Region=@{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.

Posted in All Posts, Mapviewer, OBI EE Plus | 24 Comments »

Oracle BI EE 10.1.3.3 and Mapviewer Maps

Posted by Venkatakrishnan J on August 23, 2007

As you must be knowing OBI EE 10.1.3.3 now officially supports Mapviewer Maps. This is one more reason why users must look into OBI EE. One can have visual maps of locations that can change based on data. Mapviewer is actually one of those products that is actually tightly integrated with Oracle Spatial. What this means is that if you have topographic data about your warehouses, store locations etc, all you need to do is load them up into Spatial and use Mapviewer to create the maps for you. Once you have the maps, you can integrate your maps with OBI EE. For example, while analyzing the sales for a particular region, Mapviewer maps can provide additional topographic information about the location. It also supports drilling down from the maps to the OBI EE reports. Installing mapviewer is pretty straightforward. All one would
need to do is deploy the ear file in to a OC4J container. To test this out, i deployed it on the OC4J that comes along with the OBI EE installation. It just worked like a breeze. Below is a sample screenshot.
snap1-obiee.jpg

One can get all details about Mapviewer from here

Posted in All Posts, Mapviewer, OBI EE Plus | 9 Comments »