Due to the original DWH decommission, it was necessary to migrate all reports into a new Teradata Enterprise Data Warehouse to sustain business operations.
Unfortunately, fundamental differences in the architecture between the original and new DWH disallowed a simple transfer of required reports. Data needs for each report had to be analyzed and, consequently, the reports were redesigned and re-implemented.
The majority of reports were created in Business Objects. However, some MS Excel and QlikView reports were also migrated.
Four common BO Universes were assembled during the project:
- Contact history
- Call centre performance
- Subscriber value change