Rittman Mead - Delivered Intelligence

Consider a supermarket data warehouse – you know what was sold, where it was sold and when it was sold, we can even identify what else the customer bought in the same basket. But do we really know who the customer was? Identifying retail customers at point of sale has always been problematic, other business [...]

If you have an Oracle data warehouse and are using materialized views for aggregations then Oracle dimension objects would have almost certainly been defined. These objects describe the hierarchical, attribute and join relationships for dimensions and together with database constraints enable the query rewrite mechanism to successfully rewrite queries that navigate dimensional hierarchies. Dimensional objects [...]

I see that Digital Press is about to publish a book on Oracle Data Warehouse Tuning for 10g. I hope to pick up a copy of Gavin Powell’s book soon (even though it is not out in the UK for a couple of months) and maybe review it here. The contents list looks interesting – [...]

I’ve managed to find out a bit more about the mysterious OX application that appeared on OTN’s OLAP homepage last week. What it looks like is that OX was developed by the EPB team within Oracle as an alternative to the original, 9iR2 / 10.1.0.2 version of Analytic Workspace Manager, as they had to do [...]

The next meeting of the UKOUG Business Intelligence & Reporting Tools SIG is taking place on 20th September 2005, at the Institute of Physics, London. As usual there’s an interesting line-up of speakers and presentations, including ones on Business Objects and Oracle, EPB version 2 and Oracle Warehouse Builder, plus a talk by Oracle’s Pin [...]