Rittman Mead Blog - Data Warehousing

Becky's BI Apps Corner: Incrementals and Future Dated Employee Records

During the last few posts, we have delved into a few of the many interesting aspects of a BI Apps installation. Today I wanted to change gears a bit and talk about what starts to happen when you are past installation and configuration and begin running load plans. On a

Technical

GoldenGate and Oracle Data Integrator - A Perfect Match... Part 3: Real-time ETL Challenges

I've finally had the chance to sit down and properly closeout this series on GoldenGate and Oracle Data Integrator. Since the last post, I’ve actually presented this topic on three different occasions. Once at each of the Rittman Mead BI Forums, in both Brighton and Atlanta, as a part

Technical

New White Paper on Cube Organized Materialized Views

I noticed on the Oracle OLAP blog the other day that a new white paper on Cube Organized Materialized Views has been uploaded to OTN. If you've followed Pete and my postings on this new feature in Oracle 11g the white paper goes into a bit more detail on how

Technical

Migrating OBIEE Logical Models to use a Data Warehouse : Part 3

In the final part of my series on migrating an OBIEE installation from direct application access to a data warehouse, I'm finally going to plug my new data warehouse into my OBIEE logical model. Previous to this, in the first posting I created a single logical model over three different

Technical

Migrating OBIEE Logical Models to use a Data Warehouse : Part 2

In yesterdays posting, I took a look at some of the practicalities behind my recent article on OBIEE "next-generation" architectures. The idea behind this architecture is that you can use the connectivity features of OBIEE to initially report against your data in-place, and then behind the scenes take this data,

Technical

Migrating OBIEE Logical Models to use a Data Warehouse : Part 1

A couple of weeks ago I posted an article about a next-generation Oracle BI architecture, where I advocated building a first cut OBIEE system against your operational applications, producing some "quick win" reports, and then over time copying your operational data into a data warehouse and re-pointing the OBIEE semantic

Technical

Indexing the unusual

For many years I had an interest in non-standard indexing and exotic data types, that is things that weren't NUMBER or VARCHAR2. In fact before I came in to data warehousing I was involved in indexing free text such as conversation transcripts and and narrative reports; some of this was

Technical

Data Warehouses are not dead, yet

One of the reasons that I left my old job to work with Rittman Mead Consulting was to get back to technology. Don't get this wrong, I really did enjoy managing people and having responsibility for a BI practice, but that was at the expense of involvement in a lot

Technical

OLAP and summary management

So, why is someone who normally writes about data warehouses going to talk about Oracle OLAP, and in particular, cube organized materialized views? I could run out the argument that I work in a BI consultancy and none of us here at Rittman Mead are 100% aligned to a specific