International Products Distributor

International Products Distributor

As the World’s number one distributor of Building products, with over 45,000 employees and 4,400 branches in over 25 countries.
With 220 branches coast-to-coast and more than 175,000 products, the Canadian operations are the most diverse supplier of products and customer solutions in the country. Their client base includes servicing everything from oil sands projects to retail showrooms.

Challenge
They use Hyperion Planning and Essbase for Financial Reporting, Financial & Operational Budgeting & Planning.
Now need to implement a Hyperion Planning solution for the corporate office to replace the current Hyperion Enterprise applications. Opportunity is to migrate from Hyperion Enterprise to Hyperion Planning System 11 and develop a robust Monthly Forecasting and Budgeting system. The solution will speed up consolidations and enable end user Monthly Forecasting and Budgeting in other regions in Canada.

Solution
GoLiveSystems is implementing Hyperion Planning in Phases. Phase I covered the migration of Hyperion Enterprise to Planning System 11 and migrating all the historical data into Planning. A robust integration process was also built using ODI to efficiently load and consolidate monthly data into Hyperion Planning from PeopleSoft GL. The current phase is focusing on building an enterprise wide monthly forecasting and budgeting system (Phases 2 and 3). Phase 4 will implement Management Dashboards for senior Management.

Result
Implementing Hyperion Planning and Essbase resulted in dramatic savings, in time and effort in producing monthly Reporting packages. Consolidation and reporting cycles were shortened. Consolidation time was reduced from over 20 minutes to less than 2 minutes each. A highly automated integration process enabled end users to perform consolidations in a flexible and fully audited process. End users now have quick access to the latest financial information using SmartView and Hyperion Reports.