This last month has been all about Apex for me. After OBIEE 12c installed so easily and working well, I decided its time to learn something new. Apart from buying a few books (PL/SQL Programming, Expert Apex, and Pro JQuery in Apex) I headed into the Apex World, and found…
Author: Adrian Ward
30 Years working on Oracle systems, specialising in Oracle analytics. Previously known as OBIEE, and before that Seibel Analytics
Oracle ACE
Uncategorized
Read more
New features of OBIEE 12c
So, you have the install done, and that went pretty well. Didn’t it? You can now start to play with the new toy. This week we look at the new things you play with. My favorite is the command line stuff – feels like we are back in the…
Uncategorized
Read more
OBIEE 12C Install blogs
This Week “Blogs of the Week” are about the installation of OBIEE 12c. My Favorite is the video one. Very well done everyone. I do have some advice though. Don’t assume the install steps and community comments are always applicable to your environment. I found that the proposed install location…
Uncategorized
Read more
I’m reading a book about anti-gravity. I can’t put it down
This week in the OBIEE Enterprise group on google (Join Up!) someone asked the question, How can we document the Joins in the RPD? Garish replied… Goto Tools->Query Repository Set Type to “Physical Foreign Key” Click on “Columns” button to add interesting details like the Join Expression Click “Query” Click…
Uncategorized
Read more
Movember Time
Its Movember Again. https://uk.movember.com/ Check those Balls Guys! There are a few 12c Blogs coming out, but 11.x.9 is not dead yet. See below More on Usage Tracking in the next blog. Ad. Blogs of the week 1. Customizing Charts and Graphs in OBIEE 11.1.1.9 – Quickstart Video Christian…
Uncategorized
Read more
Building on top of the Users
The Usage Tracking (UT) project will build on top of the out of the box tables, and that includes using the “SA System” ‘Users’ table as a starting point for our Users table. Have a look at Gerard blog/Wiki ( is that WikLog?) http://gerardnico.com/wiki/dat/obiee/sa and also, the all important oracle…
Uncategorized
Read more
Delete that Index
All indexes are good, right? Wrong. An index can make a join fly. but it can also slow you down. As I’ve said many times before, most of the time I delete or hide indexes, especially on an Exadata box and add carefully. However, whilst query performance is helped by…
Uncategorized
Read more
Addidici Usage Tracking Project – Part 01
Today is day one of a new project to keep me busy, The OBIEE Usage Tracking Project. The aim of the project is to build a system to analyse usage data. This will include a database build, ODI code, RPD and Catalog metadata. This will all be free to download….