Everything is SQL – the story of OBIEE
tom
As one can imagine, SQL is the main engine to start loading a report in OBIEE. In principle, one has two kinds of queries. One query runs against the Oracle…
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…
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…
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…
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…
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…
Sqoop
Sqoop is a tool that allows you to ship data from a RDBMS to a Hadoop platform. Let us take an example to clarify this. One may have some data…
Avro – getting it work
When you read about Hadoop, you come across AVRO. This is a mechanism to exchange data via streams and it is named after the famous British aircraft industry that amongst…
Map and reduce – what happens?
In Big Data, the concept of mapping and reducing plays a huge role. The idea is that a a massive dataset is split over several servers. On each server, a…
Use Case
A Use Case is something that can be written after a context diagramme is written. A context diagramme provides an overview of the whole system with its interfaces to the…