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 [https://www.rittmanmead.com/blog/2013/

Technical

New White Paper on Cube Organized Materialized Views

I noticed on the Oracle OLAP blog [http://www.oracle.com/technology/products/bi/db/11g/pdf/comparision_aw_mv_11g_twp.pdf] the other day that a new white paper on Cube Organized Materialized Views [http://www.oracle.com/technology/products/bi/db/11g/pdf/comparision_aw_mv_11g_

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

Technical

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

In yesterdays posting [https://www.rittmanmead.com/blog/2008/03/16/re-wiring-obiee-logical-models-to-use-a-data-warehouse-part-1/] , I took a look at some of the practicalities behind my recent article on OBIEE "next-generation" architectures [https://www.rittmanmead.com/blog/2008/02/15/a-future-oracle-obiee-architecture/]. The idea behind this architecture is that you can use

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 [https://www.rittmanmead.com/blog/2008/02/15/a-future-oracle-obiee-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

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

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

Technical

OLAP and summary management

So, why is someone who normally writes about data warehouses going to talk [http://www.collaborate08.com/collaborate08/] 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 [http: