Migration and overhaul of Essbase to EPM Cloud Planning

  • Practice
  • Team

1 project manager, 1 project leader, 1 Oracle expert, 3 developers​

  • Technical environment
300 users
in 80 entities
Centralize
data
Time saving
thanks to new rules
CHALLENGES
  • Our client wanted to harmonize its functional processes, which were originally managed through several specific, non-centralized developments (notably in Excel).
  • The requirement covered: the exhaustive scoping of processes and the transition from Essbase to EPM Cloud Planning.
  • Our client wanted to gain in dynamicity while maintaining performance levels. The solution was challenged in terms of response time and data quality.
  • As an additional constraint, the banking sector presents complex business models, business rules and regulations.
SOLUTION
  • After a complete review of the existing system, we set up a group application to monitor actual and budget at different granularities (Entities, Head Office and Central).
  • The global model also brings together all Essbase applications and specific Excel developments (allocation calculations, IS, cost and risk distribution at several levels of granularity).
  • EPM Cloud Planning was used to structure the process.
  • The management of access security and the audit trail enabled us to meet the sector's constraints in terms of auditability and security.
BENEFITS
  • 300 users worldwide use a single solution for different needs, saving time by standardizing processes and harmonizing bundle formats.

  • Overall improvement in consolidation performance and allocation calculations. Move from daily data consolidation to on-the-fly aggregation at each load or manual entry.

  • The switch to a standard, unified application, hosted in a publisher's Cloud, also helped reduce platform maintenance costs.