Streamlining Financial Planning, Budgeting and Reporting with SAP BPC 10.0 at Owens Corning

The Challenge

With the challenge of managing enterprise costs and spend in addition to performing financial planning and budgeting across multiple business units and regions around the world, Owens Corning was in search of a financial forecasting solution that provided credible guidance and helped to drive proactive business decisions.

The Solution

As a current SAP BPC 7.0 customer, Owens Corning decided upon SAP BPC version 10.0. Key factors leading to this solution included:

  • SAP BPC 10.0 provided integration capabilities with other (transactional/data warehousing) platforms in the Owens Corning system landscape
  • Provided the transparency they were looking for
  • Scalable solution
  • Provided a common database for each business unit’s planning and forecasting spreadsheets which provides standardized eliminations, reporting and roll-ups of results at different groupings
  • The company was already using BPC 7.0 for consolidation

Business Benefits

  • Created one version of the truth
  • More simple reporting and formatting functionality
  • Achieved better and quicker business decisions
  • Reduced the risk of forecasting error
  • Achieved a contemporary platform that is able to stay up-to-date
  • Increased process efficiency – Forecasting, Closing, Reporting

 

 

 

 

 

 

 

Building a Better Financial Consolidation solution with SAP BPC 10.0

The Challenge

With a constantly evolving matrix management structure, the consolidation process at Owens Corning was rather complex. Through the use of SAP BPC 10.0, Owens Corning hoped to gained new analytic capabilities across business units and regions through financial consolidation and reporting at various nodes and levels within the organization.

The Solution

Enabled End-to-end “lights-out” automation through:

  • Replacement of complex IBM DataStage development with streamlined standard functionality to load data from SAP ERP
  • Automated consolidation (e.g., currency translation and eliminations)
  • Leveraged TruQua tools for:
    – Auto-generation of the group hierarchy and ownership data from time-dependent entity hierarchies
    – Capturing records with bad or obsolete master data
    – Automated data validations (i.e., debits equal credits)
    – Automatic email notifications

The Benefits

  • A faster month-end closing process
  • Increased stakeholder confidence with a fast and accurate financial close
  • Improved data quality through a central controls
  • Ability to reconcile between SAP and BPC
  • Drill through capability

SAP BPC 10.0 Performance Optimization

The Challenge

Owens Corning Planning and Reporting processes were taking longer than originally anticipated.

The Solution

  • Using HP Load Runner, month-end close was simulated with 100 virtual users
  • Both Forecasting Cube and Cost Center Cube reads doubled in time
  • The response times shown in this test indicate that additional resources should be provided to the Production System to ensure good performance during Month-End Close

Business Benefits

  • After system performance optimization (increasing the resources on Prod), planning and reporting processing times were cut in half
  • Forecasting Cube and Cost Center Cube data response time and variability both reduced
  • The response time improvements shown in this test indicate that additional resources should be provided to the BPC Prod System to ensure good performance during Month-End Close
  • Model Cost Center Cube was pre-loaded with roughly 7,000,000 records, the expected Data Volume for production

Utilizing TruQua's TruQloud Environment for Project Acceleration

The Challenge

Owens Corning was on a short timeline for completing the upgrade and migration and needed to a faster, more efficient way to complete the project.

The Solution

Using TruQua’s TruQloud solution, Owens Corning was able to:

  • Migrate quicker, but providing faster access to Owens Corning’s Data
  • Upload their data to a secure Cloud Environment

The Benefits

  • Sped up their migration from what would have taken 4 months to 4-6 weeks
  • Improved reporting times by up to 20x faster