OBIEE Data Modeling Tips #3: Ragged Hierarchies

Thursday, June 21st, 2007 by Mark Rittman

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

OBIEE Data Modeling Tips #2: Fragmentation

Tuesday, June 19th, 2007 by Mark Rittman

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 Now Open

Tuesday, June 19th, 2007 by Mark Rittman

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

OBIEE Data Modeling Tips #1: Integrating 1-1 and 1-Many Source Tables

Tuesday, June 19th, 2007 by Mark Rittman

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 at ODTUG Kaleidoscope 2007

Monday, June 18th, 2007 by Mark Rittman

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

Website Design & Build: tymedia.co.uk