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

OWB11gR2 for Windows Now Available

Sunday, April 11th, 2010 by Mark Rittman

The 11gR2 release of Warehouse Builder came out for Windows towards the end of last week, firstly as part of the wider Oracle Database 11gR2 download, and then in the standalone version. Now that there’s a Windows client available to work with the various Unix server elements, everything is now in place for customers to [...]

Oracle Warehouse Builder 11gR2 – Using Code Templates – Loading Metadata from Essbase to Relational Tables – Part 2

Monday, March 29th, 2010 by Venkatakrishnan J

In the first part of this series here, i had shown how to go about using the ODI RKM’s from within Warehouse Builder to reverse engineer Essbase metadata. Though i did promise to come back sooner on the rest of the series, a client engagement completely held me away from doing this earlier. Better late [...]

Oracle Warehouse Builder 11gR2 – Importing Essbase Cubes using ODI Knowledge Modules – Part 1

Wednesday, March 17th, 2010 by Venkatakrishnan J

One of the new features introduced in OWB 11gR2 is the ability to import metadata objects through JDBC drivers. So, as long as we have an external API providing the JDBC interface to OWB, OWB should be able to leverage that and import the metadata through the API. For example, David Allan, one of the [...]

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

Website Design & Build: tymedia.co.uk