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?