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

Atlanta BI Users Group Meeting

Tuesday, February 23rd, 2010 by Stewart Bryson

Rittman Mead is proud to announce our sponsorship of the February meeting of the Atlanta BI Users Group, a regional special interest group with involvement from IOUG, ODTUG the IOUG BIWA SIG, and the Georgia Oracle Users Group (GOUSER). I’d like to thank Greg Lancaster and the entire BI team at Cox Communications for hosting [...]

Off to Denver

Tuesday, February 16th, 2010 by Stewart Bryson

I’m sitting in the Atlanta airport waiting for my flight to Denver to go to the RMOUG Training Days, which I described here. It’s snowing (again) in Atlanta, but not very much this time, and I think my flight will take off. To reiterate about RMOUG, Mark and I will be speaking about new features [...]

Data Rules and Error Handling in Warehouse Builder 10gR2/11gR2

Friday, January 22nd, 2010 by Mark Rittman

One of the less well-known features in recent releases of Warehouse Builder is Data Rules, and how they can help you gracefully handle consistency issues in your data. Data Rules act as virtual constraints on your data and add error handling tables to your mappings to allow you to divert off, or reprocess data that [...]

Website Design & Build: tymedia.co.uk