- Client
- A global mining group
- Practice area
- Finance Transformation
- Function
- 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
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!"