Rittman Mead - Delivered Intelligence

This week Jon and I took a few days out from client work, and went down to Oracle’s offices in Bristol to work on some OBIEE and SOA prototypes. Regular readers of this blog will know that I’m particularly excited about the convergence of BI and Service Orientated Architectures, as it gives us the possibility […]

Dominic Brooks posts a link to a completely fabricated tale that must be true or at least it rings true for those of use who design applications (of any kind)
I have been looking at how we can interface to a legacy Oracle 8 based CRM application and extract data to populate a new corporate data […]

I have been putting together some thoughts on Agile Development techniques for a paper for the BIWA event later in the year. I have seen a couple of articles on Agile development notably on the Amis blog, here, in the Oracle space, so thought I would add my tuppence worth.
One of the principles of Agile […]

Curiously I am working on two very similar data architecture projects at the moment, both small scale data warehouses, and both in similar subject domains. Most of the data warehouses I get involved in the are effectively a series of snapshots of a set of measures for discrete time slices be it average stock holding […]

I’m currently sitting in the deli cafe at the Hilton Daytona Beach hotel, about to leave and get my connecting flight through to Atlanta. I’ve been so busy during the past few days that I’ve not really had a chance to write about the ODTUG Kaleidoscope event that’s been running here, but now I’ve checked […]

In this third “design tip”, I’m going to look at creating ragged hierarchies in Oracle BI Suite Enterprise Edition.
Ragged Hierarchies are hierarchies where some routes down the hierarchy are longer than others; for example, you may have an organizational hierarchy for salespeople where the overall boss has two assistant managers, one of them works on […]

Following on from yesterday’s integration of a number of normalized tables into a simplified star schema, today I’m going to look at the fragmentation feature of Oracle BI Server, where a single logical table - sales, for example - can be sourced from two different physical tables, with one table holding historical data, and one […]

The BI Survey is now open for submissions: here’s the invite, pop along and answer the questions if you’ve got a spare five or ten minutes:
“We would very much welcome your participation in The BI Survey. This is the largest independent survey of business intelligence, OLAP and CPM users worldwide. The Survey will obtain input […]

Here’s a few data integration techniques that you can use with Oracle BI Server and the Oracle BI Administration tool. In this scenario, we’ve got a physical data source that’s a typical normalized transactional schema; the orders data that will go into our fact table is split into an order header record, and an items […]

Rittman Mead Consulting are represented at the ODTUG Kaleidoscope 2007 conference that’s currently running at Daytona Beach, Florida, with myself (Mark Rittman) presenting two papers and co-chairing the BI & Data Warehousing SIG along with Kent Graziano. We’ve been long-term supporters of ODTUG, the Oracle Developer Tools User Group based in the States but with […]