Business intelligence suite enterprise edition version 12. It is obvious that there are huge performance improvements as well as a new graphical engine. Building maps for oracle business intelligence analyses. Google map integration with obiee12c is not working doc id 2153327. This post describes how to setup obiee 12c but this information is also applicable to 11g and some map tweaks as wel. Maps views are produced through an integration between the oracle database, map viewer and obi but the. Oracle map viewer is included with obi and the map builder and map editor tools included with map viewer make it possible to import and customize maps. In this lesson you will learn to create an analysis, add and configure a map view.
Is important to add the table countries to decode the. How can you setup mapviewer so that you can login with a ad. Oracle bi ee 11g map views integration with mapviewer. We are available with both oracle map viewer versions 10 and 11.
Im not sure if oracle is still working on the ui since obiee 12c will have a. Oracle fusion middleware mapviewer download archive. Oracle fusion middleware mapviewer mapviewer is a programmable tool for rendering maps using spatial data managed by oracle spatial and graph or oracle locator also referred to as locator. Sep 27, 2016 this is the first in a series of posts on maps in obiee. Mapviewer is a j2ee service for rendering maps using spatial data managed by oracle spatial. Jan 11, 2014 using administration tool, in toolsoptionsrepositorysystem logging level to set the log level. I work with obiee 12c, i want to know if it is possible to modify data of the oracle map, because it can not found all city obiee oracle map viewer share improve this question. Any analysis that includes a column associated with a configured map feature is ready to be rendered in a map view without any customization or coding whatsoever.
Obiee 11g allows embedding maps in to oracle bi dashboards. File based geojson map layers that are available to visual analyzer in obiee 12c are not available to bi answers outofthebox. If you use spatial capabilities in oracle database, you should migrate to the spatial map visualization. This is a finishing post in the series about using the openstreetmap data with obiee 12c. I have been using obiee 11g from last 4 years but this is very first time i am going to use and configure obiee maps in our environment. So if you are displaying data for 5 world regions on a map, then obiee 11g will first aggregate the data and then pass over only 5 pieces of information to oracle mapviewer even if your data set consists of millions of records on the database. To enable your system to show this demo first of all create the in obiee the subject area related to the sh database sample schema.
Map views in obiee 11g once sign up, you have private instance for 5 hours available now. Obiee 10g how to drill from a map created with mapviewer. Oracle business intelligence enterprise edition obiee is a business intelligence bi tool by oracle corporation. Once the layers are created, background maps needs to be configured.
This tutorial covers using oracle map builder and oracle map viewer to build and embed maps for use in oracle business intelligence analyses and dashboards. Mapviewer is designed to integrate with locationbased services and applications. Oracle business intelligence developer client tool 12. Though the mvdemo gives you a good starting point for learning. Apart from systemwide improvements to essbase integration across obiee 11. This article provides common issues with mapviewer and obiee 12c and includes helpful troubleshooting steps. Business intelligence suite enterprise edition version 11. Maps views are produced through an integration between the oracle database, map viewer and obi but the hard part of the integration is already done so all that. This option determines the default query logging level for the internal bisystem user. Part 2 database is here many people mistakenly believe that implementing map views in oracle business intelligence obi is difficult, requires additional licensing on the oracle database and requires them to pay for content from third party map providers. The handson lab walks you through the steps involved in adding a map to an obiee dashboard. Mapviewer provides services and tools that hide the complexity of spatialdata queries and cartographic rendering, while providing customizable.
Obiee 11g allows bi administrators to preassociates the business model with mapping data so that analysis results are automatically mapready. This video shows how to consume such ootb and custom file based. Using map views and spatial analytics in obi 11g biwa summit 2014 tim vlamis dan vlamis vlamis software solutions 8167812880. Integrating maps in oracle business intelligence enterprise edition. It isnt meant to be as interactive as a real map from mapviewer which will have the. How to configure mapviewer in oracle business intelligence.
Oracle biee 11g mapviewer integration redelsilenzio tech. Verify in step 7 that the directory locations referenced for both domain and oracle map viewer are for the existing locations and not those created by the install of the update. Vlamis software founded in 1992 in kansas city, missouri. Obiee 10g and mapviewer integration frequently asked. I work with obiee 12c, i want to know if it is possible to modify data of the oracle map, because it can not found all city. Obiee 11g only passes over the summarised data to oracle mapviewer. Ill seek to set you on the correct path in this blog series. Oracle mapviewer mapviewer is a programmable tool for rendering maps using spatial data managed by oracle spatial or oracle locator also referred to as locator. This post describes how to setup obiee 12c but this information is also applicable to 11g and some map tweaks as well. This file is either shipped with the oracle fusion middleware 10 g r3 software or can be downloaded from otn. I have tried the following steps suggested in most of the blogs downloaded the mvdemo database for sample spatial data changed the configuration. I can make the map work correctly through the narrative, however i can not use it in a dashboard with filters by municipality. The previous post in the osmspatial series was finished on a simple map of germany.
Actually, i have a few more ideas, but they arent for a short term perspective. Configure background maps in the edit background map dialog, you assign each layer a minimum and maximum zoom range. Smartview as the replacement for bi office with obiee 11. This post describes how to setup the mapviewer, and the next one how to tweak the map and setup obiee. How can you setup mapviewer so that you can login with a. Integrating these maps require configuration of mapviewer which is a java application used to render maps. To assist in locating an article of interest for future reference, consider adding a bookmark. Aug 16, 2017 highend geographic information system highend gis. Then i add a map view, but the map does not render on obiee like it did on the other.
Mapviewer provides tools that hide the complexity of spatial data queries and cartographic rendering, while providing customizable options for more. This is a database dump file exported from an oracle database. Another good environment to see all the bits is in the sample app v405 obiee samples you could use any schema that you want as long as you configure the connection to it in the mapviewer configuration. Any reasons it would be grt if some body guides me for step by step integration of obiee10g with oracle map viewer. I have tried the following steps suggested in most of the blogs downloaded the mvdemo database for. We suggest you try the following to help find what youre looking for. Jul 10, 2014 obiee 11g allows embedding maps in to oracle bi dashboards. Could anybody post a tutorial link for implementing that. This post describes how to setup the mapviewer, and the next one how to tweak the map and setup obiee so, lets start. Using map views and spatial analytics in obi 11g collaborate 20. Click through the next steps, again, paying close attention to all prompts and the location for the map viewer xml file.
Oracle bi ee 11g map views integration with mapviewer 19 august 2010. Aug 19, 2010 oracle bi ee 11g map views integration with mapviewer 19 august 2010 one of the biggest new features in bi ee 11g is the ability to create native mapviewer maps and then overlay reporting componentsvisualizations on top of maps. Amit, first you do not have to use the mvdemo schema. Obiee 10g integration of a static map with mapviewer. Obiee 12c and mapviewer common issues and troubleshooting steps. Jul 10, 20 in this lesson you will learn to create an analysis, add and configure a map view. Its proven architecture and common infrastructure producing and delivering enterprise reports, scorecards, dashboards, adhoc analysis, and olap analysis provides a rich enduser. Building maps for oracle business intelligence analyses and. Map views allow you to show how your data is varying by zip code, city, state, country, continent or whatever. This is the second in a series of posts on maps in obiee.
Obiee 11g configlog file locations obiee 11g config and log file locations. For example if you are doing a country based sales analysis, its easy to color code each country across the. The map viewer sample data set comes with city, county, state, highway, and other geographical map based data that you can impose onto the map. I create an analysis with one column called territory and with one metric. Posted in maps, obiee 11g tagged map viewer, maps, maps in obiee, obiee11g, oracle maps, oracle. Hi all, i would like to implement the oracle map viewer in obiee 11g. Apr 24, 20 apart from systemwide improvements to essbase integration across obiee 11. Map views is where to start, where to find map boundary data and how to pull it together with data sourced in the subject area.
Did you check if the pictures arent blocked by csp when trying to load. Map views allow you to show how your data is varying by zip code, city, state, country, continent or. These tools can be deployed in a platformindependent manner and are designed to integrate with maprendering applications. One of the best new features of oracle biee 11g is the simplicity of integration between spatial data and biee reports. Could anyone help me out with knowing exactly what a map viewer does and what are the possibilities we can make out of it. If you are a data lover, if you want to discover our trade secrets, subscribe to our newsletter. Feb 05, 2016 file based geojson map layers that are available to visual analyzer in obiee 12c are not available to bi answers outofthebox. Navteq is one provider of this spatial data to oracle. Software downloads for oracle fusion middleware mapviewer. With the advent of 11g, mapviewer is installed as part of oracle bi enterprise edition and deployed in the same. Ans mapview administration is separate from obiee and uses different roles.
One of the biggest new features in bi ee 11g is the ability to create native mapviewer maps and then overlay reporting componentsvisualizations on top of maps. Oracle biee mapviewer integration handson lab david lapp, sales consultant, spatial. Obiee 11g and maps frequently asked questions faq peak. This chapter contains the following major sections. In the window that opens up, click on the show map button. How to add file based map layers to obiee 12c youtube. How a casino could integrate oracle maps into obiee interactive dashboards to. In this oracle by example obe tutorial you learn how to use oracle map builder to build a map, use oracle map viewer to bring the map online.
398 306 1406 307 969 1304 371 87 326 974 1413 1185 1029 1033 107 1567 1197 773 538 1033 1461 419 832 1051 373 37 1582 1463 886 1427 1070 183 1027 302 577 1178 907 1325 1385 1361 1137 1268 924 832