An Oracle Programme with a loop
tom
This programme creates an Oracle procedure. This Oracle programme has a loop. Within that loop, one record is read from a table. The content of that record is used within…
Everything is SQL – the story of OBIEE
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…
Connect SAS to Oracle
I now work in an organisation where they often use SAS as a means to maintain Oracle tables. For some reason, people approach me to create such connection. Dunno why…
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…
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…
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…