Heat Maps in OBIEE

Friday, January 22nd, 2010 by Peter Scott

OBIEE 10.1.3.4.1 has a host of ways to add visual impact to reported data to aid its interpretation. But some things are not so easy to achieve, or at least not by just clicking on a few format buttons on the Answers web page.
One of my customers had the need to report a day’s figures [...]

Collaborate 10

Wednesday, December 30th, 2009 by Peter Scott

Mark recently mentioned that he would joining Stewart Bryson (the Managing Director of Rittman Mead America) as speakers at ODTUG Kaleidoscope 2010. But before that June meeting both Mark and I will be joining Stewart at Collaborate 10 in Las Vegas. This year Collaborate will have BIWA feel about it as is running BIWA Training [...]

Capturing Change (Part 2)

Wednesday, December 30th, 2009 by Peter Scott

In the previous part I outlined the business need for writing our own CDC routines and started to outline some of the issues we would need to resolve. Here I shall outline the approach we took and describe how to go about building the SQL needed to synthesise the rows that need to be added [...]

Capturing Change (Part 1)

Tuesday, December 8th, 2009 by Peter Scott

Shortly after I joined Rittman Mead I wrote a small article on real-time Business Intelligence , there is also a link to it on our “Articles” tab. One of the techniques I mentioned in passing was change data capture, CDC.
Although many people believe that change capture is a technique for real-time or near real-time data [...]

Oracle 11g Release 2 Analytics

Sunday, September 13th, 2009 by Peter Scott

Mark and Venkat have already been blogging about OWB 11g Release 2, but that was not the only new release to slip past Oracle’s doors in recent days; 11g Release 2 of the database is also out.
I have long loved analytic functions in Oracle – they can give a simple way to avoid sub-queries and [...]

Website Design & Build: tymedia.co.uk