Skip to main content


Showing posts from 2016

How to setup geo-spatial analysis in Oracle Business Intelligence blog series

In this blog series I'm explaining all the steps required to include geo-spatial analysis in Oracle Business Intelligence, from database table preparation to adding map views to an OBIEE analysis: Setup the scene Prepare database spatial tables Setup connections required by maps and create type layer (basemap) in Map Viewer Create Geometry Themes in Map Builder Bringing OBIEE and GeoSpatial worlds together Adding Map Views to OBIEE Analysis

GeoSpatial Analytics in Oracle Business Intelligence (6)

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

My presentation about Big Data use cases at Oracle Partner Days in Krakow

I had an opportunity to present our  big data  proof of concept project that we've done couple of months ago for the Ministry of Interior of one of countries in Central and East Europe region. The project was about demonstrating some potential use cases that could be used beside regular business intelligence and analytics solutions. Today I have spoken about two use cases that addressed business problems that customer would like to resolve when faced with large (in most cases unstructured) data sets that contain valuable information. Of course doing this, there are certain challenges when facing these type of business problems, like data availability. As, we were engaged as an Oracle partner, obviously the proof-of-concept project we have developed was based on Oracle Big Data Management and Analytics platform. There were two use cases we addressed: loading and processing ustructured data and  predicting traffic accidents. Looking back, I find this proof-of-concept as r

Free Oracle Trainings by Qubix

Qubix offers Oracle Trainings for Free. There's no catch, we're sharing our knowledge for free (find more here ). Last week I ran my first Oracle Business Intelligence training in London. For this occasion we have refreshed our 11g training with the latest release of Oracle Business Intelligence 12c. Currently, the topics included in the 2-day training workshop are the following: Creating a simple table Modifying an existing report, adding Gauge views and View Selectors Creating graphs: line-bar, pie, scatter and bubble graphs Working with Waterfall charts and Column Selectors Creating simple pivot tables and using hierarchical columns in pivot tables, working with Selection Steps Interactive Dashboards: working with Prompts and with Dashboard Builder Investigating the Repository Creating and using Time Series functions  Using Analytic Functions in BI Analyses Adding interactions to Dashboards Visual Analyser and Mash-up Queries Additionally, we have reviewe

GeoSpatial Analytics in Oracle Business Intelligence (5)

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 terminology games should

OBI 12c Series: Connecting OBI with Hyperion Planning

Recently I was working with Oracle Business Intelligence 12c on a project where Hyperion Planning was used as a data source. In previous OBI releases, the usual way to connect to Hyperion Planning was to connect to its Essbase cube. In general this worked fine, but as some of readers might know, Essbase cube usually doesn't contain certain information that is a property of Hyperion Planning application. For example, comments are very important for users of Hyperion Planning, but when you report on Hyperion Planning's Essbase cube, how would you display comments that users enter into planning form? This was theoretically possible, but required a major workaround. To be honest, I haven't done that. But with OBI 12c this is very straight forward. Comments are seen as attributes in OBI's subject area, so it can be included in reports as any other attribute. This particular customer had specific requirement to show commentaries along side with numbers. Since we were t