Skip to main content


Showing posts from January, 2016

GeoSpatial Analytics in Oracle Business Intelligence (3)

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

How to purge cache in OBIEE 11g BI server

I ran into a rather general question today: "how to delete cache on my remote linux BI server?". Quite straight forward, I thought. But, and there is always a but somewhere, I didn't have BI Admin tool installed on my laptop (as you need Windows installed for that ...). And since this is not what I do most of the time I just had to do, what I do as a last resort, RTFM (read the f... manual) to get the answer that is in most cases taken as granted. To shorten my learning curve for the next time, here are some notes, what you have to do in order to purge cache on BI Server. First, let me show what can be done "manually". 1. Login into your server and open a terminal window. 2. Go to the following folder: [FMW_HOME]/instances/instance1/bifoundation/OracleBIApplication/coreapplication/setup For example, in my case: /app/oracle/biee/instances/instance1/bifoundation/OracleBIApplication/coreapplication/setup 3. Create a new text file called purgecache.tx

GeoSpatial Analytics in Oracle Business Intelligence (2)

In the first post of this series I set the scene for  our spatial visualisation. I will now describe how to prepare spatial tables for usage in geo-spatial analysis in this post. If you recall, I mentioned that there is a hierarchy of regions that has to be implemented and visualised using maps. That hierarchy has Sales regions, Chiho regions and Prefectures (Chiho and Prefecture are administrative regions in Japan). The idea is to show a map on the sales region level and than drill down to Chiho and finally to Prefectures level. I have also explained that the starting point for this is database table MAP_PREFECTURES which I found and downloaded from internet so the precision on the map might not be the best. As you saw, table MAP_PREFECTURE has already an attribute called GEOMETRY, which is of SDO_GEOMETRY type. This means that spatial information is already present. So to be able to start using in my spatial analyses I just have to perform two tasks: register MAP_PREFECTURE

GeoSpatial Analytics in Oracle Business Intelligence (1)

Lately I have been asked to prepare some proof-of-concepts for our clients that use spatial data and visualisations in Oracle Business Intelligence (OBI) dashboards and reports. In general there are demos on internet showing how you can use a map view in an analysis. But how do you actually get there, it is never shown. So I decided to share this with whomever is interested and here it is. Preparation and deployment of spatial data in order to be used in OBI visualisations is a 5 step process: Prepare data in Oracle database Configure and create layers in Oracle MapViewer Create styles and geometry themes in Oracle Map Builder Import and configure layers and background maps into OBI Add new map views into analyses Setting the scene In this post I will focus on preparing data in Oracle database. I will use Oracle Spatial Data Option for creation of required spatial objects. As you will see, there are some new spatial data object types involved, but in general this is not