A while back I wrote a post about how to combine measures from different facts in an OBIEE analysis. If you missed that then…
Read more →There have been quite a few posts on the Oracle OTN Forums E-Business Suite space recently with people asking some kind of variation of…
Read more →I wanted to write this as an introduction to combining data from multiple facts/subject areas into a single analytic. The post is aimed primarily…
Read more →With a lot of E-Business Suite customers looking to upgrade to R12.2.x within the near future (if they haven’t already), I thought it might…
Read more →So a couple of weeks back I had a quite an exciting moment. Why? Well I downloaded myself an E-Business Suite R12.2.4 Vision virtual…
Read more →Oracle Application Express (APEX) is increasingly being used to produce custom developments within Oracle E-Business Suite. I’ve posted previously about how to configure your…
Read more →I recently needed to use the LISTAGG function in a custom Oracle ODI interface. However to my dismay I found that ODI didn’t recognise…
Read more →The WITH clause (or subquery factoring clause) is a very useful construct. It allows us to materialize the results of a SQL statement to…
Read more →I thought this worth talking about as I’ve been in discussions with a number of people recently around best practices for data types etc.…
Read more →It is quite common for warehouse developers to customise standard processes to add additional fields. Ideally this is done by modifying the appropriate mapping(s)…
Read more →