Use BAdIs to Create Master Data-Driven Validation Rules in BusinessObjects Planning and Consolidation, version for NetWeaver

  • by Andrew Simmonite, Senior Technical Strategy Consultant, Capgemini (Technology Services)
  • September 27, 2011
Data integrity is essential in the budget or forecasting process. By enforcing data integrity, you can ensure that reliable reporting is available when used for business decision making. Using a typical forecast scenario as an example, follow the steps to implement a master data driven validation rule in SAP BusinessObjects Planning and Consolidation, version for SAP NetWeaver, as a way to enforce data integrity.
Key Concept
When business users enter their budget or forecast data, checks are often needed to ensure the integrity of the data prior to write-back. Using the standard validation function, administrators can define specific rules that validate the integrity of data before it is saved back to the database, rejecting any data that does not meet the specified requirements. You can also implement a generic rule that is controlled via master data, delivering a flexible solution and reducing the administrative burden that a standard solution provides.

Using a Business Add-In (BAdI), you can configure a planning application to execute a master data driven validation rule that ensures data integrity. This method can simplify a work status configuration that is often used to perform the same task, but requires the administrator to manually apply these to each budget or forecast that is created. I explain how to implement a master data driven validation rule using a BAdI.

This article is for SAP BusinessObjects Planning and Consolidation functional and technical team members who want to implement flexible validation rules in versions 7.0, 7.5, and 10.0 of SAP BusinessObjects Planning and Consolidation, version for SAP NetWeaver.

To implement an example of this solution you need to complete four tasks:

  • Create an example planning application using the predelivered AppSet APSHELL, which you then apply the validation rules.
  • Set up a validation rule for a BAdI implementation.
  • Configure the master data properties that are used to define the validation rule.
  • Implement the validation BAdI to enforce the validation rule when data is saved back to the database.

Finally, you can also see the validation rule in action.

Andrew Simmonite

Andrew Simmonite is a senior technical strategy consultant for SAP NetWeaver BW with Capgemini. He has more than nine years of experience with SAP NetWeaver BW and more than 19 years in IT. He has experience in both reporting and planning implementations for multi-national companies in the gas and oil, public-, and retail sectors. He holds a bachelor degree with honors in computer science.

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.