New White Paper on Cube Organized Materialized Views

Tuesday, March 25th, 2008 by Mark Rittman

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 it works, and in our […]

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

Monday, March 17th, 2008 by Mark Rittman

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 application data sources, and in […]

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

Sunday, March 16th, 2008 by Mark Rittman

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, load it into a data […]

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

Sunday, March 16th, 2008 by Mark Rittman

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 model to point to this […]

Indexing the unusual

Monday, March 10th, 2008 by Peter Scott

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 pushing the technology of the […]

Data Warehouses are not dead, yet

Sunday, March 9th, 2008 by Peter Scott

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 of the delivery of systems; […]

OLAP and summary management

Saturday, March 8th, 2008 by Peter Scott

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 expertise area; for example I do […]