← All insights
Case study

A global mining group: Chart of accounts mapping in minutes, owned by the business

From mapping rules too heavy for Anaplan to 30,000 rules applied to 700,000 records in about 2.5 minutes.

2.5 minutes

to apply the mapping rules to the SAP records

30,000 rules

applied to 700,000 SAP records

Client
A global mining group
Practice area
Finance Transformation
Function
  • Group Finance
  • Financial Reporting
  • Chart of Accounts management
The problem in one line
Applying chart of accounts mapping rules to SAP data in Anaplan was too slow, and Anaplan could not run the first set of mappings at volume.
The outcome in one line
Business users now run and edit the mapping themselves, and the full run takes about 2.5 minutes.
Technologies used
  • Alteryx
  • Alteryx Server
  • Anaplan
  • SAP BW
  • SAP
  • HFM

Background

A large international mining company needed a Global Chart of Accounts and reporting within Anaplan across all its entities. Its SAP systems were inconsistent and related to HFM. Mapping tables were needed to resolve SAP GL accounts to HFM accounts, and then to reporting metrics in Anaplan.

Applying these mapping tables to SAP BW data in Anaplan was time-consuming. The company turned to Dimago for a way to apply the mapping logic efficiently.

The Challenge

The company needed a flexible, editable process, owned by business users, to build and maintain the mapping tables. The Anaplan approach was inefficient with many mapping rules and took a long time to process. Business users needed to apply complex mapping logic without writing code.

  • Inconsistencies across SAP systems and their relation to HFM.
  • Mapping tables had to be created and maintained.
  • Applying many rules to SAP BW data in Anaplan took significant processing time.
  • Anaplan could not run the initial set of mappings at the volume of data involved.
  • Business users could not apply complex mapping logic without code.

The Solution

Dimago built the mapping process in Alteryx, which connects to Anaplan for data transfer between the systems. Dimago worked with the business users to understand requirements and gave guidance on best practice for mapping logic. Business users developed and checked mapping rules step by step.

  • Mapping logic sits in the workflow, so the company can set up and maintain mapping tables efficiently.
  • Business users iterate on mapping rules with Dimago, and can make changes during reporting periods.
  • Alteryx connects to many data sources, handles large datasets and applies complex logic without code. Future SAP fields can be added to the mapping without workflow updates.
  • The workflows run on Alteryx Server, on a schedule or ad hoc during critical financial reporting periods.
  • Business users have a "real-time" view of their reporting and no longer depend on others for updates.

The Impact

  • Runtime: 30,000 rules applied to 700,000 SAP records in about 2.5 minutes, a significant decrease compared with Anaplan.
  • Anaplan could not run the initial set of mappings at this volume, so Alteryx let the project complete.
  • Better validation of the mapping rules, for accuracy and reliability.
  • More mapping rules can be added later without extensive development or workflow updates.
  • Business users iterate faster on mapping logic.
  • Business users own and control the mapping process.
  • Business users see the state of their reporting in real time, which supports timely decisions.

"In terms of performance improvements…Anaplan couldn't actually run the initial set of mappings as it couldn't handle the volume of data being processed in bulk, hence why Alteryx was introduced. Not sure how we measure that, but a massive improvement in the process nonetheless!"

The client's team

Key takeaways

Moving heavy mapping logic out of Anaplan and into Alteryx cut the run to about 2.5 minutes.

Business users own and edit the rules, with no code and no wait on others.

New SAP fields can be added without changing the workflow.

Finance Transformation

Talk to us about your Finance Transformation

Want business-led automation and AI solutions for your team?

60-minute session. Bring a process, we'll show you how we'd fix it.