Oracle BI Enterprise Edition 11g has been around for many years now and there are many people using 11.1.1.7 versions. This goes out of…
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 →Good to see that BI Applications 11.1.1.10.1 is now available. Some quite interesting features with this release including Taleo support and an interesting looking…
Read more →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 be present in previous…
Read more →Session variables are used in the OBIEE repository for (amongst other things) setting user context information for use in analytics and dashboards. These can…
Read more →This blog entry is based on some feedback from a quick live demo I did at the UKOUG joint BI and Finance SIG in…
Read more →