SAP BusinessObjects Planning and Consolidation 7.x, Version for NetWeaver: Introducing Script Logic

  • by Velavan Trichy, BPC Solution Management, SAP BusinessObjects
  • March 10, 2011
Become acquainted with the script logic functionality available in SAP BusinessObjects Planning and Consolidation 7.x, version for SAP NetWeaver. Review use cases for script logic, its architecture, various ways to execute it, and a few basic key words.
Key Concept
Script logic is a set of instructions that executes custom business calculations either online or by batch processing. SAP delivers a set of keywords and functions that accept parameters. Using them, customers can implement business calculations on the data. All planning and consolidation tools provide similar scripting languages. For example, SAP provided FOX for Integrated Planning/Business Planning and Simulation. However, script logic in SAP BusinessObjects Planning and Consolidation 7.x, version for SAP NetWeaver is much different than other scripting languages in its use of keywords (as far as their syntax goes) and overall functions (as far as how those keywords are executed in the scope data)

Script logic functionality in SAP BusinessObjects Planning and Consolidation, version for SAP NetWeaver helps business users execute custom business logic, anything from simple mathematical operations to complex allocations. It helps in executing this logic in the server side either online or in batch mode. Business users are now able to write or execute this logic right from Admin/Microsoft Excel clients making it much more easily accessible. It also provides means for advanced programmers to code complex logic.

I’ll introduce script logic functionality for new users who intend to work in the SAP NetWeaver 7.x version of SAP BusinessObjects Planning and Consolidation. It is based on keywords from SAP BusinessObjects Planning and Consolidation, version for SAP NetWeaver 7.0 Support Package (SP) 08/SAP BusinessObjects Planning and Consolidation, version for SAP NetWeaver 7.5 SP03 release and any following releases of BPC. While I tried to keep this article for beginners, basic knowledge of SAP BusinessObjects Planning and Consolidation and SAP NetWeaver is recommended. You can refer to the series of SAP BusinessObjects Planning and Consolidation articles posted at for more details.

Originally, script logic was a proprietary language of OutlookSoft, which was acquired by SAP. The original OutlookSoft product continues to be shipped by SAP as a separate product (called SAP BusinessObjects Planning and Consolidation, version for Microsoft). Its script logic originated from the Microsoft version of script logic. I do not cover Microsoft’s script logic keywords and functions and do not discuss the differences between two versions. Script logic is coded in the SAP BusinessObjects Planning and Consolidation Admin client. The Admin client provides the ability to validate and save the script to the server (Figure 1).

Velavan Trichy

Velavan Trichy T works in the SAP Business Planning and Consolidation Solution Management group, managing both the SAP NetWeaver and Microsoft BPC products. In his current role, he is responsible for understanding market requirements; defining, assembling and packaging solutions; and enabling the field and ecosystem to successfully bring these solutions to market. Before this, he worked with Fujitsu Consulting as a principal consultant for four years. During this time, he worked in all areas of SAP NetWeaver BI, from ECC extractor configuration/enhancement, all the way through to complex reporting using BEx and WAD. He has also lead multiple projects, covering high volume SAP NetWeaver BI data warehousing design and implementations, as well as global projects. Velavan also has extensive planning experience, has worked on SEM-BPS, BI-IP and BPC projects, and has also implemented the SEM Management Cockpit and BSC. During his time at Fujitsu, he contributed to its SAP BI Center of Excellence, building multiple tools to ease/automate project realization steps, as well as presented papers at SAP BI conferences. Before this, Velavan worked at Intelligroup, where he gained experience in Pharma clients and designed and implemented custom Analytical applications. He has also worked at Tata Consulting Service, where he first started using BW 1.2B.

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.