Collaborate 10 – The Early Days

Tuesday, April 20th, 2010 by Peter Scott

One of the things I had expected to do this week was to write about some of my BI and DW highlights from Collaborate 10. However, that is not to be. I am currently sitting at home in the UK, a victim of a cloud of volcanic ash that has locked down aviation in Northern [...]

Realtime Data Warehouses

Thursday, April 8th, 2010 by Peter Scott

In a little over two weeks I will be giving my Real Time Data Warehousing talk at Collaborate 10 in Las Vegas. I will cover a variety of techniques and not just change data capture. However, in my opinion, CDC plays a major part in the practical implementation of a realtime data warehouse. It is [...]

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

Website Design & Build: tymedia.co.uk