As part of Accenture’s journey to implement a more powerful ERP, the global IT organization identified Accenture’s SAP Business Planning and Consolidation (BPC) application to be upgraded to version 10.1. The application is Accenture global Controllership’s primary consolidation tool for external reporting and SEC filings. SAP BPC supports the financial process and regulatory reports, including more than 14.5 million movements for more than 700 companies each period. Staying current with SAP application upgrades is also in keeping with Accenture’s guiding principles and in maintaining its “SAP system as an asset” strategy. For these reasons, Accenture was ready to upgrade to the latest version for managing financial information and its consolidation.
The project team installed SAP BPC 10.1 on SAP HANA® with the goal to support a broader International Financial Reporting Standards (IFRS) program with a technical solution for consolidations that addressed three objectives. The objectives were to 1) Enable parallel sets of results; 2) Take advantage of Accenture’s new SAP Business Warehouse (BW) on HANA system to gain efficiencies in the consolidations business process; and 3) Reduce report execution time and consolidation runtime. The installation was carried out following Accenture’s global IT organization’s release schedule and standard methodology.
To enable parallel sets of results to support a broader International Financial Reporting Standards (IFRS) program, global IT explored different SAP BPC architecture options. Global IT, in collaboration with an SAP consultant, designed a consolidated SAP BPC road map. This road map took into consideration the latest versions, different upgrade scenarios and future direction of SAP solutions. It will be reviewed at future checkpoints to determine when to perform the next upgrade and to which version of SAP BPC. This approach enables global IT to better understand the state of the art in SAP’s BPC product evolution and determine the most appropriate fit for Accenture.
As part of migrating Accenture’s SAP BW system to SAP HANA, Accenture chose this opportunity to lead in the “New” and migrate its first major SAP application to the public cloud. With its SAP BW on SAP HANA on Microsoft Azure, the project team looked to gain efficiencies in the consolidations business process. To achieve this objective, Accenture selected the more skilled resources in the business and technology and integrated them in a very collaborative team with a focus on performance improvement. At the same time, the project team worked closely with global Controllership to make sure the results satisfied their needs.
To reduce report execution time and consolidation runtime, the project team designed and executed an exhaustive testing plan. This testing revealed that the process of obtaining report information from the SAP BPC repository consumed a great deal of time in validating user access. To address this performance issue, the project team optimized user roles to reduce the time required to perform validation.
Additionally, as part of the implementation, the project team designed an improved Year-to-Date logic with the objective of reducing the amount of records loaded in an SAP BPC cube each period and saving load time. Instead of loading all records from the SAP system for the current fiscal year, the new logic computes the initial balance for all previous periods into a single set of data added to the current period in month-end close. This in-house development helped Accenture make the close process agile and improved performance.
People and culture
Before the BPC upgrade to version 10.1, consolidating regulatory reports as part of the financial process was a complex effort for our financial close team and the business. Given that the amount of records to process was continually growing, the BPC loads were taking longer and longer. This situation placed extra demands on the teams to address issues, monitor mitigation of risk and complete the process.
Today, performance of the loads has greatly improved, virtually eliminating risk to the scalability of the model and risk of impacting subsequent financial close activities. The upgrade and enhancements the global IT team made were contributing factors as well as the migration of SAP BW on HANA. The financial close team now has confidence in the tool, allowing members to gain time for other, higher-value activities as well as have more agility and flexibility with the consolidation process. They also have an improved work/life balance.