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 …
Optimistic Row Locking in Oracle Application Express (APEX)
As is common with stateless web-based applications, Oracle Application Express (APEX) utilizes an Optimistic locking mechanism when updating data via …
Oracle BI Cloud Service (BICS) – Going Beyond SampleApp
One of the products Oracle are currently pushing very heavily is Oracle BI Cloud Service (BICS). BICS allows customers to …
Monitoring Oracle Data Integrator (ODI) Load Plan Executions with BI Apps
Update – 22/08/2018 I have added a simple version of the Load Plan Monitor to GitHub (Available Here). Please provide …
Integrating external command line tools with Oracle data
One thing I find interesting to explore is the integration of different tools with Oracle which may not always be …
Oracle 12c – Adaptive Execution Plans
Having not done a great deal with Oracle 12c, I was quite excited today to see an adaptive execution plan …
Selectively Enabling Fields/Flexfields on a Query Only Oracle Form Using Personalizations
Selectively Enabling Fields or Descriptive Flexfields on a Query Only Form We have recently worked for a client who wanted …