Geography Hierarchies

Tuesday, May 24th, 2011 by Peter Scott

I have been thinking about address a lot recently, in part it was moving house and all of the 1001 people that need to be notified. In the main, though, it was thoughts inspired by a data warehouse project I am working on. For this DWH people are geo-located by their street address, but for [...]

Regular Expressions in OBIEE

Friday, December 18th, 2009 by Stewart Bryson

When reporting against an OLTP system, in many ways, OBIEE works like an ETL tool, transforming the source system data and presenting it as a star schema. After years of writing ETL code, if there’s one thing I hate to be without, it’s regular expressions. So, when working on a project to map an OLTP [...]

Data quality is not a one-off

Wednesday, November 12th, 2008 by Peter Scott

In my Blog post on End-to-end data quality I mentioned the desirability of fixing bad data at source. This certainly attracted comment both here and on other blogs for example One point to keep in mind about fixing bad data on the source; it is just that, fixing DATA. We are not fixing bad applications [...]

End-to-end data quality

Saturday, October 25th, 2008 by Peter Scott

One of our customers is about to embark on a significant BI project; but being in the “public sector” they have to (by EU law) publish tender documents so that qualified suppliers throughout the EU can bid to do the work. This means they have a gap of almost a year before the, yet to [...]

Being Flexible

Saturday, October 18th, 2008 by Peter Scott

One of the things I really love about working with the team here at Rittman Mead is how we can offer our clients a flexible service, I guess this flexibility must be appreciated by our customers as we have just won the UKOUG Business Intelligence Partner of the Year award. The past week I have [...]

Website Design & Build: tymedia.co.uk