Combining Facts/Subject Areas in Oracle OBIEE
I wanted to write this as an introduction to combining data from multiple facts/subject areas into a single analytic. The …
Table configuration in E-Business Suite R12.2 to support Online Patching
With a lot of E-Business Suite customers looking to upgrade to R12.2.x within the near future (if they haven’t already), …
A quick look into E-Business Suite R12.2.4 Vision
So a couple of weeks back I had a quite an exciting moment. Why? Well I downloaded myself an E-Business …
Querying HR Secured Views in Oracle Application Express
Oracle Application Express (APEX) is increasingly being used to produce custom developments within Oracle E-Business Suite. I’ve posted previously about …
Using LISTAGG and other meta columns in ODI interfaces
I recently needed to use the LISTAGG function in a custom Oracle ODI interface. However to my dismay I found …
(Mis)using the WITH clause in Oracle
The WITH clause (or subquery factoring clause) is a very useful construct. It allows us to materialize the results of …
Predicate Evaluation Order – Using Generic Fields
I thought this worth talking about as I’ve been in discussions with a number of people recently around best practices …
Post Load Processes – Don’t Neglect Your Statistics!
It is quite common for warehouse developers to customise standard processes to add additional fields. Ideally this is done by …
*)nqgtu(* – Working Around an Odd Bug in OBIEE
Note: This post relates to an issue which has been produced in Version 11.1.1.7.150120 for the purposes of this blog. It may not …
Extending and Enhancing the use of Variables in the OBIEE Repository
Session variables are used in the OBIEE repository for (amongst other things) setting user context information for use in analytics …