Žiga Vaupot's Blog

It's about time to finalise my series on Geo-spatial analysis in Oracle Business Intelligence. In this post I'm just laying out the necessary steps to add new map views to your analysis. A dashboard with some reporting objects. The idea was to replace the top left table with a map view. In order to do that, the following steps need to be taken: 1. Open dashboard Electronics Dashboard (initial). 2. Click Page Options and select Edit Dashboard option from the menu. 3. Notice that Electronics Dashboard consists of two objects: On the left side, there is a dashboard prompt and on the right, there is a compound view of Map-sales region v1 analysis. 4. We will focus only on Map-sales region v1 analysis. So let's edit it. 5. Click Results tab to view some results first. 6. As said, we need to replace Table view with a Map view. So let's create a new map view first. 7. Map view opens. From the list of available maps, select Electronics (this is th...

Bringing the two worlds together It's been almost a month since my last post on geo-spatial analysis in OBIEE ( GeoSpatial Analytics in Oracle Business Intelligence (4) ). We still have this and one more to go, so let's not waste any more time. So far, we have prepared database spatial objects , prepared maps to be used as a background in our analysis and created all required map objects . Now we need to bring those objects into OBIEE and map that to column in subject areas. From your Home page click on Administration link and select Manage Map Data  link. To perform the task described above, we need to set up Layers  and then link these with Backgrounds . You will  notice that terminology used in Map Builder  has changed slightly. We now talk about Layers  which we created in Map Builder as  Geometry Themes . We created Tile Layers  in Map Viewers , which are now called Backgrounds . Quite innovative, isn't it? But nevertheless these ter...

I explained steps necessary to setup spatial data to be available for analyses in OBIEE in my previous steps: Setup the scene ,  Prepare database spatial tables   and Setup connections required by maps and create type layer (basemap) in Map Viewer . In this post I'm stepping one more step further, so let's investigate what tasks one has to perform in Map Builder. Oracle Map Builder is a standalone application that lets you create and manage the mapping metadata (about styles, themes, and base maps) that is stored in the database. For example, use this tool to create a style or to modify the definition of a style. Besides handling the metadata, the tool provides interfaces to preview the metadata (for example, to see how a line style will appear on a map) and also spatial information. Whenever possible, you should use Oracle Map Builder instead of directly modifying Oracle MapViewer metadata views to create, modify, and delete information about styles, theme...

In my two previous posts I have set the scene for spatial analysis in OBI and prepared database tables . I'm going to continue this example by preparing Tyle Layers in Map Viewer. Oracle Fusion Middleware MapViewer enables developers to incorporate highly interactive maps and spatial analysis into business applications. 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. It is also fully integrated with Oracle Spatial and Graph. In addition, it is included in Oracle products such as Oracle Business Intelligence and Oracle applications such as Utilities, Transportation, and Communications. Key MapViewer features are: Rich user experience and faster performance through HTML5-based JavaScript APIs Combine content stored in an databases, JSON and XML files with content from online web services Mobile support for popular iOS and late-version Android devices Web-based map data ed...