SAP BusinessObjects Planning and Consolidation: Read Dimension Members and Their Properties from an AppSet Using a BAdI
- by Thiagu Bala, Aster Logic, Inc., President
- September 13, 2010
Find out how to use a Business Add-In in SAP BusinessObjects Planning and Consolidation to read the dimension members and their properties within the same AppSet or any other AppSet. This enables you to create reports from data that you access in two different applications.
Business Add-Ins (BAdIs) furnish developers with the ability to extend the SAP application to realize unique business logic not available in the SAP standard delivery. While the concept of BAdIs was introduced as early as SAP R/3 Release 4.6, only as of SAP NetWeaver 7.0 has this technology been integrated in the new Enhancement Framework and been based on ABAP Objects. You can use BAdIs for numerous reasons, such as to personalize the application to meet a requirement for your industry or country.
A typical SAP BusinessObjects Planning and Consolidation implementation has one application set (AppSet) with several applications (i.e., sales planning and profitability planning) in the same AppSet. Because most planning applications are tightly integrated, you often may need to look up application data from another application (or look up a dimension member or dimension member attribute) and then execute business logic on the data. In the case of SAP BusinessObjects Planning and Consolidation, you can do this by using a Business Add-In (BAdI) to furnish lower-level access to AppSet dimensional data and transactional data.
For example, say you use the sales planning application to plan the monthly sales by material. You need to calculate the cost of the goods sold. The cost for each material is stored in a different cost application. You could use the BAdI to read the cost from the cost application and use it in the sales plan application logic.
I provide a sample ABAP program (available to download below) that explains how to read the dimension members and their properties within the same AppSet or any other AppSet using this feature. My scenario uses a BAdI to read another application’s data based on a member’s property or attribute. In my example, I want to read promotion data stored at the product group level in the promotion application based on the product attribute from the source application, sales.
This example requires the following software:
- SAP NetWeaver BW 7.0 with an SAP BusinessObjects Planning and Consolidation Add-on
- SAP BusinessObjects Planning and Consolidation 7.0, version for SAP NetWeaver
- .NET server
Would you like to see this full item?