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 […]

Website Design & Build: tymedia.co.uk