Obiee 10g with mapviewer integration flash demo peak. The obiee answers platform is mashing up project information, stored in spreadsheets, with a sales territory map based on the sales region name. Under layers tab click on import layer button at the right. Mapviewer provides services and tools that hide the complexity of spatialdata queries and cartographic rendering, while providing customizable options for more advanced users. Bip and mapviewer mash up ii oracle bi publisher blog. Mapviewer its main deliverable is a j2ee application that can be deployed to a j2ee container, such as that for oracle fusion middleware. Jan 10, 2007 5 viewdownload the users guidean updated pdf version of the mapviewer users guide 4. To assist in locating an article of interest for future reference, consider adding a. Login to obiee as an administrative user go to administration link at the top right hand corner click on manage map data. The previous post in the osmspatial series was finished on a simple map of germany.
I have a very less knowledge about map viewer as how to integrate them with obiee by using the mvdemo schemas and rpd. Building maps for oracle business intelligence analyses and. Download the mapviewer mvdemo data into your oracle database oracle provides preconfigured maps, coordinates, and navteq data that use can use in your reports. This post describes how to setup obiee 12c but this information is also applicable to 11g and some map tweaks as well. When you have eliminated the javascript, whatever remains must be an empty page. I like to think it was like kevin costners waterworld, a nice idea but poorly executed and a flop at the blog box office but it would have been a perfect map for. Obiee 11g tagged map viewer, maps, maps in obiee, obiee11g, oracle maps, oracle spatial, spatial leave a. Unzipping this patch will give you the six patches listed above. Download the pre built sample data mvdemo as dump from oracle site. Oracle business intelligence enterprise edition 11g with mapviewer. Mapviewer is installed as part of oracle bi ee and deployed in the same.
Oct 12, 2011 bip and mapviewer mash up ii the current approach to get the maps into the output using encoded concatenated url strings works but if you need to make changes to the map request call it gets fiddly and annoying quite quickly and if you need to drop another map into another output youll need to embed the code into the second rtf template. This demonstration will show you not only mapviewer integration with bi dashboards, but also with bi publisher. Obiee answers, publisher, installation, configuration and work around tips. Obiee report developer resume profile hire it people we. Oracle fusion middleware mapviewer download archive. Obiee 10g how to drill from a map created with mapviewer. Download the mapbuilder jar file from this location or the oracle site based on your version. May 06, 2014 oracle map viewer is a java based web application used for representing maps with in a web page. So kindly, share some of your experience and show some demos or steps to implement this requirement. Map builder kitthe new map builder desktop application um themeslayer zu editieren vereinfacht geht es dann so weiter. The latest release of the onpremises version of obiee, 12. Map viewer in obiee 11g part 1 datawarehouse architect. There seems to be a little problem with the jdk link, here is the link to download page.
Integrating maps in oracle business intelligence enterprise. It isnt meant to be as interactive as a real map from mapviewer which will have the. Mapviewer is shipped as part of oracle fusion middleware. Well, a quick web search found this note about using external tile layers, this note about how youve got to configure your data before using an external spherical mercator tile layer read the rest of that for more mvcustommaptilelayer info and and this example. Download sample rpd for map view here sample data for rpd here configure and load the rpd and database and check if the connections create a schema mvdemomvdemo for the same rpd password is admin12345 configure the map viewer step 1. With 10g, you have to use the mapviewer javascript api, the nsdp features non spatial data provider. Browse other questions tagged oracle11g obiee jmapviewer oraclemapviewer or ask your own question. Obiee 10g and mapviewer integration frequently asked. Its available on the software downloads for oracle fusion middleware mapviewer page. Mapviewer installation of the demo files gerardnico the. Please note that you will need an oracle database for storing the layers e. This article talk about a static integration of a map created with mapviewer for obiee 10g.
Hi guys, i have one requirement in the spatial data. 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. Mapviewer installation of the demo files gerardnico the data blog. Here is a list of faqs about obiee 10g and mapviewer integration, we. Mapviewer is a j2ee service for rendering maps using spatial data managed by oracle spatial. Oracle bi ee 11g map views integration with mapviewer. Im not sure if oracle is still working on the ui since obiee 12c will have a. Step 4 import the map meta data 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. To install and launch map builder, run the command from the c. In obiee 10g you can directly edit i file, instance config.
Actually, i have a few more ideas, but they arent for a short term perspective. I have extensive experience on obiee 10g version previously although currently i am on obiee 11g. In line graph data labels in graph view are coming on the line so some values are not readable, we have to show values always how can we move the data labels above the line or below the line. Oracle map viewer is a java based web application used for representing maps with in a web page.
In 11g, mapviewer is tightly integrated and configurable. Either before or after you install and deploy mapviewer, read chapter 2 to be sure you understand important terms and concepts ensure that you have the prerequisite software see section 1. When the user clicks on one of the state counties, we want to drill down in the map to that county and have the related obiee charts update to display that countys information. Expert on obiee 11g reports design and development including rpd, metadata development with obiee 11g map viewer obiee publisher with hippa rules. It can be deployed to most j2ee application servers such as oc4j, apache tomcat, web logic etc. Mar 30, 20 once it is restarted, click on data sources. Bridge tables and many to many relationships demystified in obiee 11g bridge tables entire books have been devoted to this concept, countless blogs write about it, and organizations offer entire classes dedicated to demystifying this idea.
This article provides common issues with mapviewer and obiee 12c and includes helpful troubleshooting steps. Bip and mapviewer mash up iv oracle bi publisher blog. Its main deliverable is a java ee java platform, enterprise edition application that can be deployed to a java ee container, such as that for oracle fusion middleware. This performance architects how to video explains on how to deploy and configure the mapviewer in oracle business intelligence enterprise edition obiee 11g. Mar 17, 2009 you mentioned that map viewer would be required for drill down capability. David lives and breathes maps and probably knows the oracle gis solutions better than the folks that wrote them. Sep 29, 2012 step 4 import the map meta data 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. How to create spatial tables for map viewer datawarehouse. Though the spatial data is available from several vendors, we will be referring data from navteq, which is available as a free sample download from oracle technology. In the window that opens up, click on the show map button. 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. Blog a modern hello, world program needs more than just code. Mapviewer provides tools that hide the complexity of spatial data queries and cartographic rendering, while providing customizable options for more. Mapviewer with oracle business intelligence enterprise ed obiee.
Download the spatial schema provided by navteq from the. You mentioned that map viewer would be required for drill down capability. This is a finishing post in the series about using the openstreetmap data with obiee 12c. Obiee 10g integration of a static map with mapviewer.
After a standard installation of obiee 10g or 11g, you can find them on this url. Caching of map tiles for any base map at the midtier support of features of interest foi. A component of oracle fusion middleware, it lets you combine application content with maps and data from a variety of web services and data formats. A 5 minute recorded demonstration showing the powerful capability available through oracle bi ee and mapviewer integration. Oracle fusion middleware mapviewer enables developers to incorporate highly interactive maps and spatial analysis into business applications. To get started using mapviewer, follow these steps. I record all issues and finding in oracle bi, that i can refer back later, or others can use for troubleshooting. Oracle business intelligence enterprise edition obiee 11g r1 11. How to configure mapviewer in oracle business intelligence. This post describes how to setup the mapviewer, and the next one how to tweak the map and setup obiee so, lets start.
Could anyone help me out with knowing exactly what a map viewer does and what are the possibilities we can make out of it. Instruction on how to install the oracle mapviewer 10g 10. Download the mapbuilder application which will enable to create a custom maps. I can make the map work correctly through the narrative, however i can not use it in a dashboard with filters by municipality. Sep 23, 2012 step 4 import the map meta data 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. Download from otn the new map builder desktop application download the map builder kit the new map builder desktop application. You will get the home page to create data source for creating a connection to bi. Sep 29, 2011 as youll see if you go back to the original post, i have dabbled, i know how to render a map view in obiee but i knew i needed to lean on our resident map meister david to take this forward. Obiee report developer resume profile hire it people. Quite some time ago now i wrote the first of what i thought were going to be at least a couple of articles on getting bip to render maps via oracle mapviewer. P oracle123 this is the password for user weblogic used to login on obiee websitedashboard. As long as you are licensed for obiee 11g then you are able to use the map viewer engine that is installed as part of the obiee 11g product suite. Map viewer in obiee 11g, map viewer, obiee, obiee 11g.
Oct 03, 2017 download the mapbuilder jar file from this location or the oracle site based on your version. If your intended use falls under the terms of the otn license, you should be able to download the software from the oracle technology network and install it. Step 4 import the map meta data the map viewer sample data set comes with city, county, state. It was a real helloworld example with no world just the hello bit. Nov 24, 2015 step 4 import the map meta data 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. 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. Business intelligence suite enterprise edition version 11. 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. Start the mapbuilder application and login to the respective schema to start creating maps. This is a downloadable zip file containing a complete mapviewer demo including sample data and instructions. It is obvious that there are huge performance improvements as well as a new graphical engine.
Obiee 11g only passes over the summarised data to oracle mapviewer. Webbased applications such as obiee 11g can embed maps within their web pages simply by making calls to oracle map viewer. Select type of map source as oracle maps and click on continue 9. Obiee 10g uses mhtml as the formatting code when downloading files to excel. Extract the zip and launch the map builder by double clicking on the file. But youd have to determine whether the otn licenses.
1305 1499 1596 1549 627 275 1072 1136 1246 285 31 1590 1521 1203 1004 506 1190 866 958 779 858 678 1101 832 203 1149 461 1368 711 558 78 1438 1237 1487 566 268 737 1003 491 1497 339 968