Build Powerful Exit Functions in Integrated Planning

  • by Pallavi Kale, BI Consultant, Deloitte Consulting India
  • August 21, 2012
Many times standard SAP BI Integrated Planning functions are limited in scope and do not achieve the desired results when complex calculations or company-specific logic are involved. In such cases, exit functions are a tool that can take care of almost any kind of complex logic.
Key Concept

Exit functions are custom planning functions, based on a custom function type that is developed using a custom ABAP class. These functions provide flexibility to restrict the processing of data based on different parameters, arrange selected reference data including an actual date, and build your own logic for critical situations. For example, you can combine actual and planned data. You can use standard interfaces provided by SAP to build the base custom classes. Once the function type is designed, you can use it in several planning functions.

Every company has its own planning strategy based on its business model and experience. For example, media companies can have a planning interface to budget and forecast their marketing campaigns. In the media industry, unlike other industries, the products are sold or dispatched as a part of a subscription on a periodic basis.

From a planning perspective, the forecasted marketing campaigns are unrealized campaigns. The data for all unrealized campaigns comes from customer relationship management campaign master data. The planner calculates the revenue, response, gross margins based on the estimated customer base, attrition rate, sales, and cost. Once the campaign is realized, the actual data starts building up in SAP ERP Central Component (ECC).

At a given time, it may happen that you have actual data coming from ECC for the delivered subscriptions and planned data for subscriptions that are yet to be dispatched. To fine-tune the forecasting process, the actual data needs to be considered while determining key performance indicators (KPIs). The challenge is to combine the actual and planned data for calculations while restricting the write access only to the future plan data.

Pallavi Kale

Pallavi Kale is an SAP-certified BI consultant with more than seven years of experience covering all aspects of SAP NetWeaver BW, from extraction to reporting. She is an expert in Integrated Planning and possesses working knowledge of other SAP BusinessObjects tools, such as Crystal Reports, Web Intelligence, Xcelsius (now known as BusinessObjects Dashboards), and SAP Planning and Consolidation. She has helped companies to implement complex data warehouses in the fast-moving consumer goods, manufacturing, networking, and media industries.

To contact the author, click here: Pallavi Kale. If you have comments about this article or would like to submit an article idea, please contact the BI editor.

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.