A simple introduction into creating spatial report

I write this to show you how to use Oracle Map Builder and Map Viewer to create spatial reports within Oracle BIEE. I assume you have a set of tables that can be used to generate future spatial reports. I use three tables: [1] Edge that contain a filiaal_num as an identifier and a point… Read More »

Using OBIEE spatial reporting

Using spatial reporting in OBIEE is not for the faint of heart. However it is also rewarding. The reports look great; it is new and henceforth exciting. It is challenging but the outcome stands out. However on the route to the reports, some obstacles must be overcome. Let me provide some thoughts on the obstacles… Read More »

Spatial Reporting in OBIEE

OBIEE allows you to create spatial reports. The idea is relatively simple. Instead of a tabular reports with rows and columns, we create a reports that are createad as a layer upon a map. So we have a map, with a layer of plotted values. When we have a report with a geographical component, such… Read More »

Latitudes and longitudes in the Netherlands

Getting geographical data on Holland is not a trivial matter. It took me a bit of tenacity to get the data. Hence I thought being a good idea to store my findings. I might need these data in the future. The first file that I found on the internet is a file with longitudes/ latitudes… Read More »

Oracle OBIEE – My First Report

Recently, I created my first OBIEE report. To be honest, my biggest problem was to identify which tools to use. I might overlook the clues, but it took me quite some time before I could identify the important tools that I had to use. Finally, I understood that two important tools must be used: [1]… Read More »

Oracle OBIEE

Recently, I came across OBIEE. This is an Oracle tool that is created to support OLAP – type investigation into a database. I have to confess: I am impressed with it. The first great thing for me as an analyst is that it closely integrated into existing Oracle tool. One may continue to use the… Read More »

Generate table in Oracle

I regularly happens to me that I want to generate a random set of records in an Oracle table. That could happen if we want to assess performance of a certain procedure. Or (other example) if we want to estimate the size of a table. A great thing of Oracle is the random function where… Read More »

Scoop and Hive

It is possible to use Scoop to directly load from a RDBMS into Hive. This opens interesting possibilities. Data that are stored in a RDBMS and that need to be analysed on a cheaper platform, can be migrated via Scoop to a Hadoop platform. Scoop is generaly seen as a reliable medium to undertake such… Read More »

Hive – mapreduce extension

It is good to realise that Hive is built upon a mapreduce framework. The idea is that Hive is developed by facebook to facilitate analysis on Hadoop files. It is possible to use some kind of a SQL dialect in stead of a Python or a java programme to do your analysis. When a Hive… Read More »

Python: yet another way to implement map/ reduce

In this blog, I will discuss the word count problem as done with Python. It is often used to show how map reduce works. In most examples, it is developed within the context of a Java programme. The idea is that the programme is split into two stages. In one stage, calculations are made on… Read More »