Thoughts on Change Data Capture

Tuesday, March 9th, 2010 by Peter Scott

In little over a month I will be in Las Vegas speaking at Collaborate 10. There is a lot of BI / DW talks this year and for the first time with BIWA Training Days branding. Rittman Mead will be there at the conference giving talks on each of the conference days. If you are [...]

Oracle 11g Pivot

Tuesday, February 23rd, 2010 by Peter Scott

One of the things that I often come across is the “up-dateable fact”, that is a fact that starts life “incomplete” and changes overtime. Examples include things such as support calls that start life as “open” then progress through “responded”, “resolved” and finally “closed”; statuses in the sales cycle such as ordered, paid, shipped; stock [...]

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 [...]

Website Design & Build: tymedia.co.uk