Technical Oracle Data Integration Suite Keeping my head down building Oracle 11g OLAP cubes for research and self-education meant the I missed yesterday's product announcement from Oracle, but with the wonders of Blog aggregators (and in particular Beth's [http://feeds.feedburner.com/InfoQualityAggregator]) I spotted a mention on Vincent McBurney'
OBIEE Hybrid OLAP Reporting using MS Analysis Services & Oracle One of our clients called me in today to run an OBIEE workshop. They have a number of Microsoft Analysis Services cubes that they'd like to report on using OBIEE, and if possible they'd like to combine this summary-level data with some more detailed data in
OWB11g, DML Error Logging and Data Rules One of the new features in OWB 11g (and back-ported to OWB 10.2.03) is support for DML Error Logging. DML Error Logging is a database feature introduced with Oracle 10gR2 that lets you add a LOG ERRORS clause to your DML statement, so that DML operations that would
OTN Article on OBIEE and SOA [http://www.oracle.com/technology/pub/articles/rittman-biee-soa.html] If anyone's wondering why there's been so few postings on the blog over the past couple of months, it's mainly because I've been writing some longish articles for OTN and Oracle Mag on
Technical Quality thoughts as I continue to chill out Over at another Blog, Beth [http://datageekgal.blogspot.com/2008/01/data-quality-changes-large-and-small.html] notes that she is editor of the month for the Carnival of Data Quality. When It comes out I urge you to take a look. With those strange quirks of global IT companies Beth and I once
BIPublisher and mySQL The other day I was asked to look in to how we can use BIPublisher to report against a mySQL database. According to the documentation one can report against basically any database that can be connected to via JDBC. Obviously I am assuming you already have your mySQL database up
Technical Some New Oracle OLAP and Essbase Blogs Just a quick posting on Saturday morning to mention some new Oracle OLAP and Essbase blogs that I've come across. First up is an Oracle OLAP blog [http://oracleolap.blogspot.com/] by some of the most well-known people behind the product. Kevin Lancaster (well known to us at
Still here and going to New Orleans Just a quick post to tell people I am still alive. Haven't been blogging for close to two months now so I thought I'd better show a small sign of life. I spent New Year's eve up in Iceland, visiting friends and family. As
Back in Action Well, this must just about be the longest stretch of time between a blog post in the last couple of years. After the Christmas break and a trip with the family to Egypt, I'm finally back in action and raring to go. Christmas was a bit of a
OWB quirkiness Recently, I mentioned a quirk in OWB 10.2 with a dimension table target configured as a type 2 slowly changing dimension. We have been working on some load performance problems with straight-forward OWB maps. As part of this investigation we wanted to change some of the hints being used
Technical Used unused indexes One of my old customers had a data warehouse with a three-area design model: a staging area for data load/cleanse, a third normal form (or more 3-NF-like than dimensional) raw data layer and a denormalised dimensional layer containing aggregated data for reporting. They ran a retail business and one
Technical A flat world A lot of data warehouses get some (if not all) of their data feeds through data files; in fact I can't recall a recent project where at least one feed from an external system did not arrive as some form of flat file. I have had customers whose
Top Ten Oracle BI&DW Events of 2007 Well, the presents are wrapped, the cards are sent and the turkey is stuffed, but before we close down for the Christmas break I thought it worth coming up with a Top Ten Oracle BI&DW Events of 2007. Starting from ten and working down to one, and with
New Oracle Magazine Article on OBIEE and Oracle IdM The latest edition of Oracle Magazine [http://www.oracle.com/technology/oramag/oracle/08-jan/index.html] comes with a new article by myself and Joel Crisp on Oracle BI Suite Enterprise Edition and Oracle Identity Management. Entitled "Intelligence and Identity" [http://www.oracle.com/technology/oramag/oracle/08-jan/
UKOUG and ODTUG BI Abstract Submissions Now Closing A quick posting on two BI-related conferences that are currently accepting abstracts for presentations but due to close soon. The UK Oracle User Group is holding a Business Intelligence & Performance Management Special Event [http://www.ukoug.org/calendar/show_events.jsp?year=2008&month=03&day=18]
More on Oracle OLAP 11g and Query Rewrite Over the past few days I've been taking a closer look at how query rewrite works with the new 11g release of Oracle OLAP. As a quick recap, in Oracle 11g you can now use OLAP analytic workspaces as summaries within your data warehouse, with Oracle now able
Migrating OBIEE Reports Between Web Catalogs One of the questions I always get asked during my BI seminars is how you migrate OBIEE requests and dashboards from one Web Catalog to another. The context of this is usually that you're putting your project into production, or test or whatever, you've migrated the
Integrating Oracle OLAP and ApEx A demo I've seen at several Oracle events over the past year is one where ApEx (Application Express) is linked in with Oracle OLAP. The idea is that the charting and reporting capability of ApEx is used against the SQL views over an Analytic Workspace, giving you the
Business Insights UKOUG Wrap-Up Just to finish off the postings from last week's UKOUG Conference, I've uploaded the three presentations that I gave during the week, which can now be accessed using these links: * Integrating Oracle BI Suite Enterprise Edition and Oracle Fusion Middleware [http://www.rittmanmead.com/files/Integrating%
Days 2 and 3 at the UKOUG Conference I'm sitting up in the speaker lounge at the UKOUG Conference, getting thing sorted out for my "Advanced Development Techniques with Oracle BI EE Plus" masterclass later this afternoon. After the fourth night out in a row - last night with Dimitri Gellis and Jon Scott
Day 1 at the UKOUG Conference I'm currently sitting in the lobby area of the Jurys Inn hotel, having just missed the 9.30am finish of the breakfast service and currently therefore putting together an impromptu breakfast of coffee and custard creams that they've left out. I'm normally up with
Reminder : UKOUG Blogger Do, Monday Evening 8pm A couple of people have asked me where the blogger do [https://www.rittmanmead.com/blog/2007/11/20/ukoug-2007-blogger-meetup-pitcher-piano-brindley-place-8pm-on-monday-3rd-dec/] is being held tomorrow night - it's at the Pitcher and Piano [http://maps.google.com/maps?f=q&hl=en&geocode=&time=&date=
Arrived for the UKOUG Conference Well I've finally arrived in my hotel room in Birmingham for the UKOUG Conference, no jet lag or long flights for me this time as of course this conference is on home turf. The good old British transport system almost got it's revenge though, with a
The UKOUG 2007 is starting Well, it was about time that I woke up from my non-blogging slumber! I have been keeping my attention on customer work and easily managed to put off blogging for quite some time now. I dare say I should try to keep the pace a bit better here and I
Details on The RedDatabase Symposium I've finally got around to updating the events [http://www.rittmanmead.com/events/] page on our website, taking down the old Open World and ODTUG events and uploading details of the UKOUG Conference and some of the engagements already booked in for 2008. One of the events next
