Know who your customers are – part 1

Wednesday, August 31st, 2005 by Peter Scott

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

Validation of dimensions

Friday, August 26th, 2005 by Peter Scott

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

New Book

Friday, August 26th, 2005 by Peter Scott

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

More On The Mysterious “OX”

Thursday, August 25th, 2005 by Mark Rittman

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 a lot of development work directly with [...]

News on the Forthcoming UKOUG BIRT SIG in September

Thursday, August 25th, 2005 by Mark Rittman

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 Patel on how Oracle’s BI&W
products integrate together. [...]

Website Design & Build: tymedia.co.uk