http://www.rittmanmead.com Delivered Intelligence Mon, 08 Feb 2010 21:55:39 +0000 http://backend.userland.com/rss092 en In the introduction to this series of posts, I spoke briefly about data warehouse fault tolerance and the unique challenges resulting from high data volumes combined the batch load window required to create them. I then defined the goal: a layered approach allowing simple errors to be caught early before ... http://www.rittmanmead.com/2010/02/08/data-warehouse-fault-tolerance-part-1-resuming/ One of the biggest differences between Essbase and most other reporting/OLAP tools like BI EE/Oracle OLAP etc is in the way Measures are treated(comparison only in terms of data modeling and reporting and not on physical implementation). In Essbase, every data/value(cell) is attributed by a set of dimensions. Even a ... http://www.rittmanmead.com/2010/02/03/oracle-bi-ee-10-1-3-4-1-modeling-measure-dimensions-on-relational-sources-essbase-style/ With so much of the blog devoted to OBIEE, OWB and Essbase lately, I felt like it was time to do a few database-related postings. In the past, when I've posted database content to the blog, I usually gravitate toward ETL-related features: those that waffle between database administration and ETL ... http://www.rittmanmead.com/2010/02/02/data-warehouse-fault-tolerance-an-introduction/ As you will see from Venkat's Football blog, we ran a demo of the OBIEE system at last years UKOUG.  The demo was based upon the English Football Premiership, and although I prefer rugby, using sports in samples is a great way to highlight the features of OBIEE.  It seems that some sports, ... http://www.rittmanmead.com/2010/02/02/fantasy-football-when-is-a-fact-not-a-fact/ One of the few things that i have been working on this week is in understanding how the recently released Fusion Middleware 11g will influence Oracle BI EE in the near future. As was demonstrated & presented in the last Open World by Oracle, the strategic direction of Oracle is ... http://www.rittmanmead.com/2010/01/28/oracle-fusion-middleware-11g-bi-adf-components-first-impressions/ The annual RMOUG Training Days event takes place on February 17th and 18th in Denver, CO, with some additional university sessions taking place on February 16th. I am excited to be co-presenting with Mark Rittman on A DBA and Developers' Guide to Oracle Warehouse Builder 11gR2. Quite often, when we ... http://www.rittmanmead.com/2010/01/27/rmoug-training-days/ [Fieldwork for the BI Survey 9, an independent survey of BI customers and partners, closes its fieldwork on Sunday 31st January. It's important that we get a suitable number of Essbase, OBIEE, OLAP and Discoverer users completing the survey, so please visit the site and fill it in if you've ... http://www.rittmanmead.com/2010/01/27/the-bi-survey-9-fieldwork-closes-on-sunday/ If you're considering coming along to the BI Forum 2010 we'll be holding in Brighton in May 2010, we'd be interested in hearing your opinion on what sessions we'll be running. The call for papers is now closed and we have 27 potential sessions, from speakers around the world. The ... http://www.rittmanmead.com/2010/01/25/bi-forum-2010-abstract-voting-now-open/ 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 ... http://www.rittmanmead.com/2010/01/22/heat-maps-in-obiee/ 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 ... http://www.rittmanmead.com/2010/01/22/data-rules-and-error-handling-in-warehouse-builder-10gr211gr2/