SAP BusinessObjects Planning and Consolidation

Add Sophisticated Enhancements Through the Shared Query Engine BAdI

  • by Ryan Leask, Senior Director, Solution Strategy for SAP’s Business User and Line of Business Sales Organization
  • Prakash Darji, Senior Director of Solution Management in the Enterprise Performance Management Area Within SAP BusinessObjects
  • January 5, 2010
Discover a few of the available ways to enhance SAP BusinessObjects Planning and Consolidation, version for SAP NetWeaver. These enhancements often take the form of BAdIs and are implemented through ABAP coding. The authors take you through a detailed example of one such BAdI, the Shared Query Engine BAdI, and supply the code necessary to adapt the process for your own needs.
Key Concept
BAdI is an abbreviation for Business Add-In, which was introduced to replace the old approach to enhancements in ABAP: the user exit. Think of a BAdI as a sophisticated, object-oriented user exit.

The Shared Query Engine (SQE) BAdI enhancement option recently became available in Support Package 4 of SAP BusinessObjects Planning and Consolidation 7.0, version for SAP NetWeaver. The SQE is the component in SAP BusinessObjects Planning and Consolidation through which all read requests go. For example, when a user is in the BPC Excel client and wants to pull the data from the back-end SAP NetWeaver BW system, the SQE handles the request.

Similarly, if a user wants to run a planning function (such as an allocation), the SQE manages the data read from the SAP NetWeaver BW InfoCube. Figure 1 depicts the high-level flow for both a read and write request in SAP BusinessObjects Planning and Consolidation, version for SAP NetWeaver. It is important to keep in mind that while Figure 1 shows the requests generated by an end user, many components within SAP BusinessObjects Planning and Consolidation (such as Data Manager, Script Logic, and Consolidations) also call the SQE and write back components.


Figure 1
End users read and write requests in SAP BusinessObjects Planning and Consolidation, version for SAP NetWeaver

Note
We assume that you are familiar with the basic terminology of SAP BusinessObjects Planning and Consolidation, and that you understand a little about programming (ideally ABAP programming and BAdIs). If you don’t have the requisite knowledge of SAP BusinessObjects Planning and Consolidation, we recommend checking out the series of articles we have published in BI Expert. These articles start with the basics and progressively cover more details about the product.

Ryan Leask

Ryan Leask currently runs the SAP BusinessObjects Planning and Consolidation solution management team for SAP, based out of Palo Alto, CA. Prior to this position, he led the EPM solution architecture team with a main focus on the design of SAP BusinessObjects Planning and Consolidation 7.0, version for SAP NetWeaver. Ryan has also worked on SAP xApp Analytics, SAP NetWeaver Visual Composer, SAP NetWeaver BW, SAP SEM, ABAP, SAP CRM, analytics/data mining, and whatever else seemed interesting. He has also co-authored SAP xApp Analytics (SAP PRESS, 2006), written many articles, and presented at numerous conferences.

See more by this author

Prakash Darji

Prakash Darji is currently director of product management in the Enterprise Performance Management area within SAP Business Objects. In his current role as a director of product management for the SAP BusinessObjects Planning and Consolidations product, his responsibilities include inbound product management through working on the short- and longer-term roadmap for SAP's Planning Solutions, managing deliverables for multiple releases, as well as creating product specifications for innovative features and functions to differentiate against key competitors. His full bio is available at: www.linkedin.com/in/prakashdarji.

See more by this author


Comments

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.