Case Studies Terex Corporation's Transition to OneStream for Unified Financial Management
Edit This Case Study Record

Terex Corporation's Transition to OneStream for Unified Financial Management

Analytics & Modeling - Predictive Analytics
Platform as a Service (PaaS) - Application Development Platforms
Platform as a Service (PaaS) - Data Management Platforms
Construction & Infrastructure
Transportation
Business Operation
Quality Assurance
Cloud Planning, Design & Implementation Services
Software Design & Engineering Services
System Integration
Terex was using Oracle Hyperion Financial Management (HFM) and Oracle Hyperion Financial Data Quality Management (FDM) for financial consolidation, close, high-level budgeting, and reporting. For detailed budgets, they relied on several point solutions such as Prophix for one of their segments and Excel for others. They faced a major and costly upgrade of their HFM and FDM applications and realized there would be a lot of data migrations required to keep HFM and EPBCS in sync. Terex began evaluating OneStream as a unified solution for financial consolidation, close, reporting, and all their planning needs. They saw an opportunity to start fresh with a single solution for both actuals reporting and planning, with enough detail to accommodate both processes in a single system. OneStream’s platform could eliminate painful data administration performed by the FP&A team, and its Extensible Dimensionality® would allow for the elimination of Prophix, which was used for line-of-business planning. Additionally, OneStream offered a robust technology solution built on a 64-bit architecture, with multi-threading of calculations, and the ability to be deployed via the Microsoft Azure cloud. Terex found OneStream’s customer references to be enthusiastic and 100% positive, which firmed up their decision to move to OneStream’s unified platform.
Read More
Terex Corporation (NYSE: TEX) is a global manufacturer of lifting and material processing products and services delivering lifecycle solutions that maximize customer return on investment. Major Terex brands include Terex, Genie, and Powerscreen. Terex solutions serve a broad range of industries, including construction, infrastructure, manufacturing, shipping, transportation, refining, energy, utilities, quarrying, and mining. With revenues approaching $5 billion, Terex has approximately 12,000 employees and operates manufacturing facilities throughout the world.
Read More
With the help of OneStream partner CompIntelligence, Terex laid out a nine-month implementation plan that included addressing both actuals reporting and planning simultaneously. They designed a hybrid chart of accounts that replicated the HFM chart required for consolidation and reporting and extended it with the details required by the FP&A team. This approach allowed the consolidation team to work concurrently with FP&A, building models and integrations. They also did three months of parallel closes before going live on OneStream in November 2018. The prior approach to budgeting and planning using HFM, Prophix, and other systems at Terex placed many limitations on the FP&A team. HFM had limited dimensionality to capture the detail required to plan by product lines, brands, functions, geographies, plant sites, and customers. This led to the creation of supplemental schedules to collect the data. There was no concept of extensibility to support future growth into models or planning by SKUs. Planning was very manual with limited ad hoc scenario analysis and no automated way to seed forecasts or run currency impact scenarios. With OneStream, Terex was able to create a detailed chart of accounts for the business in one application, which allowed them to collect the granular level of detail needed in one central place. Step-by-step workflows now guide users through the budgeting process and allow each segment to budget the way they manage their business. They improved the quality of intercompany data by creating an auto-matching process. Budgeting sales by geography has been made easier for users by creating percent allocation forms.
Read More
The consolidation and reporting process is significantly simplified with OneStream. The organization structure was reduced to 140+ reporting entities with 85 automated workflows.
97% of reporting entities are now loading directly from their 28 ERP systems, easing the burden on the corporate team.
The number of rules needed was reduced from over 15,000 to less than 1,000 rules.
Consolidations reduced from 18 to 20 hours to less than 15 minutes.
Nine months to go-live on OneStream for consolidation, reporting, and planning.
Download PDF Version
test test