Case Study:

Eskom

Project description

Topline Essbase and DDW Oracle - Enhancements and Support
Classification
Ongoing Strategic BI & Analytics Partnership
Project Duration
March 2019 – Present
Country
South Africa

The Challenge

Eskom, South Africa’s primary electricity utility, needed a single, reliable platform to reconcile commercial revenue (from detailed customer billing) with financial revenue (from SAP consolidated financials).

Key challenges included:

  • Disparate data sources and complex reconciliation between granular billing data and high-level SAP totals
  • Legacy top-down budgeting processes that lacked customer-level visibility
  • Requirement for both detailed views (large/key customers) and aggregated summaries (small consumers)
  • Need for accurate bottom-up forecasting, statistical revenue tracking, and integrated dashboards for the BI department

Our Solution

Digital Knowledge, through Account Manager, Project Manager, Data Engineer, Data Analyst, and Oracle Hyperion Essbase Consultant Robert Dobson, has delivered continuous enhancements and support for the Topline Essbase and DDW Oracle platform using an Agile delivery framework.

 

Key deliverables include:

  • End-to-end integration of customer billing data with SAP financial revenue
  • Oracle Hyperion Essbase solution for multi-dimensional analysis and consolidated reporting
  • Bottom-up forecasting capability with customer-level budget and forecast capture
  • Development of business intelligence, analytics, dashboards, and reporting requirements for Eskom’s BI department
  • Full solution design, architecture, infrastructure, and seamless end-to-end integration

 

Premium Solutions

Results & Business Impact

  • Enabled seamless reconciliation of commercial and financial revenue at both summarised and detailed levels
  • Transformed budgeting from traditional top-down to accurate bottom-up forecasting at individual customer level
  • Delivered intuitive dashboards and reports that provide a single view of consolidated bill details, statistical revenue, and aggregated accounting
  • Significantly improved decision-making precision and agility for revenue analysis, trend identification, and operational planning
  • Provided a robust, scalable platform that continues to evolve with Eskom’s changing business needs
  •  
Key Solutions

Technologies We Used

Oracle Hyperion Essbase Platform

Oracle Hyperion Essbase Platform

Oracle Business Intelligence Stack

Oracle Database, Oracle PL/SQL, Oracle SQL

Oracle SmartView Reporting

Oracle SmartView

Data Modelling & ETL Architecture

Data Warehouse (DDW Oracle)

28+

Years of Experience

The Outcome

Business Benefit

Eskom now has a powerful, customer-centric analytics platform that turns complex billing and financial data into actionable insights - driving greater financial accuracy, operational efficiency, and proactive market responsiveness.
Sales Support

+27 (0)82 823 1815

Email Support

info@digik.co.za

Next Steps

Ready to achieve the same revenue clarity and forecasting power in your organisation?

Digital Knowledge
Privacy Overview

This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.