Data warehouse for energy trading

The model of the existing DWH is completely revised. This involves implementing a set of rules for the relationships between dimensions, and including new attributes and key figures. The ETL process is restructured using the Oracle Warehouse Builder (OWB) and expanded to include essential new functions (e.g. logging dimensions in histories, late arriving facts, automating the load run and archiving). The connection to the source systems (including Endur) is then completely revised. Additionally, the model (Universum) and the front-end tools (Business Objects XI) are restructured. Standard reports for users are consolidated and the performance of queries improved. The data is then migrated from the old system to the target platform.