Automate Your Data Compilation Processes with BPS – It’s Not Just for Planning

  • by Matt Christensen, Director of Enterprise Performance Management, PRAGMATEK Consulting Group
  • February 15, 2006
Do you have users collecting time spent on projects in spreadsheets and emailing them throughout your organization to be compiled? Do you extract financial results and perform Excel-based calculations for management reports? Are you developing product or project quotes for customers in a spreadsheet that is not integrated to your operational system? Learn how to use Business Planning and Simulation (BPS) to cut operating expenses and reduce cycle times associated with data collection and processing.
Key Concept

The Business Planning and Simulation (BPS) module enables the customized development of structured and dynamic input layouts and functions that update information directly into Business Information Warehouse (BW) InfoCubes. This concept can standardize and streamline many common business processes. BPS was formerly delivered only within the Strategic Enterprise Management (SEM) framework. SEM itself is installed as an add-on to an underlying BW installation. While it remains a component of SEM, BPS is also delivered within the core BW installation as of Release 3.5, further promoting its use as a cross-functionality tool set.   

Business Planning and Simulation (BPS) provides for data entry into a centralized business intelligence environment to enable enhanced operational planning and subsequent enterprise performance improvements. You should not discount the capabilities of this tool set by limiting its involvement to your planning processes.

You could cast any existing process that involves compilation of data in a spreadsheet or repeatable calculations of results by an administrative user into a BPS-based solution. I’ll explore three example scenarios – information collection, allocation of actual expenses, and project quotation. Then I’ll walk through the steps you take automate them within BPS.

In a subsequent article, I’ll describe how to use BPS for recognizing the transfer of expenses within your SAP accounting modules. For example, you can retract the results of time collection from the analytic system back to the R/3 or ERP Central Component (ECC) system.

Keep in mind that BPS is like a box of building blocks. It is intended to facilitate ease of customization to fit your specific needs, so the examples that follow are intended to whet your appetite as much as they are intended to provide concrete solutions.

Matt Christensen

Matt Christensen is the director of Enterprise Performance Management at PRAGMATEK Consulting Group in Minneapolis. He has more than seven years of experience implementing a broad set of SAP financial modules, including configuration and development in R/3, Business Information Warehouse, and Strategic Enterprise Management. Matt holds an undergraduate degree in computer science and an MBA in finance.

See more by this author


No comments have been submitted on this article. 

Please log in to post a comment.

To learn more about subscription access to premium content, click here.