Optimize BW’s Data Modeling Capabilities with BPS

  • by Peter Jones, BI Solution Architect, M16 Solutions
  • April 1, 2006
Make the jump from reporting in BW to planning and data modeling using BW’s Business Planning and Simulation (BW-BPS). See how the InfoCubes, attributes, calculated key figures, and dimensions for planning differ from those you use in reporting. Get valuable tips about properly structuring your planning InfoCubes.
Key Concept

A characteristic is an object that you can use to report with, such as employee, company code, or sales organization. A characteristic adds information to a transaction.

An attribute is an object that describes a characteristic, including employee name, Social Security number, and address.

Starting with SAP BW Release 3.5, you can use its Business Planning and Simulation (BPS) functionality to analyze your data in new ways and create plans, budgets, and forecasts.

Although both the reporting and planning sides of BW use the same platform for querying data, the requirements and focus vary. Different rules apply to data modeling in a BW-BPS environment than for reporting. The data modeling rules that allow an InfoCube to efficiently read data and generate queries are neither necessary nor consistent with what you need to read and write the data and generate plan information.

Prior to implementing BPS, you must review the planners’ requirements and planning layout formats to understand what functions they may need later. Also, you must make sure that your InfoCubes include the characteristics and key figures related to your planning requirements. A simple way to do this is to develop a BPS design document to give the configuration group the necessary characteristics and key figures that planners need.

I’ll review data modeling methods and investigate the different approaches to accommodate BW-BPS processes and data modeling around configuration of InfoProviders, variables, and other structures in BW. I’ll focus on the data modeling issues from the application side of the process and identify required and optional components to efficiently construct an InfoCube for BW-BPS. I’ll show you how to use BW hierarchies, characteristics, key figures, dimensions, and attributes of an InfoCube in planning, as well as data modeling and planning BW-BPS functionality.

Peter Jones

Peter Jones is a business intelligence solution architect in the areas of CO, EC, SAP BW, BI, BusinessObjects, Planning and Consolidation (BPC), and SEM for MI6 Solutions. He is certified in all these areas and is a subject-material expert for SEM, CO, BI, and BPC, with over 14 years of experience in these areas working for SAP and MI6 Solutions. Currently, he is involved in projects incorporating SAP BW 7.4, HANA, BPC 10.0, and EPM 10.0. He has consulted in all those areas for the last nine years. Peter was an SAP instructor for seven years and has written several books about SAP NetWeaver BW, FI/CO, and has recently revised his book about BPC Implementation to version 10.1. He is a contributor to Best Practices for Financial Reporting in SAP, an exclusive anthology of articles that delivers unparalleled guidance on how to optimize financial reporting processes with SAP applications.

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.