OLAP Newsletter Customer Feature

Severn Trent Water Plc have implemented a Data Warehouse on Oracle Database 10g with OLAP option, Business Intelligence Standard Edition (BI SE) and Warehouse Builder (OWB) to store and provide analysis of 5-6 million daily readings of water monitoring assets. The Data Warehouse stores 5 years of such data which results in a 1.5 Terabyte Data Warehouse. The timely availability of the information generated from these readings provide analysis capabilities for 400 users. Oracle OLAP is implemented for its ease of implementation in the Oracle Database, fast pre-summarisation of multi dimensional data, and complex calculations; speedy retrieval of information allows fast decision making in key areas. The analysis of operational KPIs related to wastage, usage and costs enables low costs to customers, the ability to meet environmental targets, and operational and cost efficiency for Severn Trent Water.

Technical Solution:

Oracle Partner Edenbrook implemented the BI solution for Severn Trent Water. The cubes are 4 dimensional with the largest dimension storing 1.5 million values. The TIME dimension can drill to the day level and there is also a Timeframe dimension so that around 35 KPIs and water licence data metrics can be analysed for a very specific time period. Discoverer OLAP delivers color coded reports and drill out to the transactional level of detail in the Warehouse.

David Watts, Information System Project Manager at Severn Trent Water states "Oracle Business Intelligence gives us an end-to-end view of operations ‘from brook to tap and back’ and provides relevant, timely, usable data for performance monitoring and decision making."

Fred Dean, OLAP Consultant at Edenbrook states "Implementing Oracle OLAP as part of the Data Warehouse solution at Severn Trent Water provides fast operational analysis of the company's KPIs; they are also able to forecast on existing trends and seasonality to provide even better cost efficiency and control within company, and environmental targets. Technically, the solution is easy to manage and is very cost effective. Overall it's a simple, cost effective, money saving solution."

About Severn Trent Water:

Severn Trent Plc is the world’s fourth largest privately owned water company and serves eight million households and businesses in an area covering 10,000 square miles. The quality of its drinking and handling of waste water ranks above the industry average. Their customer bills are among the lowest in the United Kingdom. www.stwater.co.uk

See Oracle Snapshot on this implementation here.

View more Oracle OLAP Customer and Partner references here.