A Guide for Using Formulas and APIs in SAP BusinessObjects Analysis for Microsoft Office

  • by Anurag Barua, Principal, TruQua Enterprises
  • May 17, 2017
SAP BusinessObjects Analysis for Microsoft Office version 2.3, the eventual successor to the BEx Analyzer, has not only incorporated most of the Analyzer features but also has significantly expanded its scope while improving the end-user experience. The SAP Formula Library and the Application Programming Interface (API) Library, discussed in-depth in this article, are two tools that extend and expand the power of the Microsoft Excel Visual Basic for Applications (VBA) programming language macros and add value to data.
Learning Objectives

Reading this article, you will:

  • Gain a good understanding of formulas and application programming interfaces (APIs) in SAP BusinessObjects Analysis for Microsoft Office and their purposes
  • Learn how to use selected formulas
  • Learn how to use selected APIs
Key Concept
SAP BusinessObjects Analysis for Microsoft Office version 2.3 provides the SAP Formula Library and the SAP API [application programming interface] Library, both of which enable analysts to uncover deeper facets of data and metadata to make their analyses more meaningful. The API Library is a concept that has been around for decades.

Serious Excel users, such as analysts, probably have extensive experience using Microsoft Excel’s library of formulas. SAP augments this capability by providing a library of formulas that enable advanced analysis. Why should this matter to you? The answer is simple: Microsoft Excel provides you with general functions, while SAP BusinessObjects Analysis for Microsoft Office formulas provide functions that are tailored to extracting the maximum information from your SAP functionality, data, and metadata. Additionally, by combining these formulas with those provided natively by Microsoft Excel, you can build some additional capabilities that enhance the power of SAP BusinessObjects Analysis for Microsoft Office.

Note
For a complete list of formulas, application programming interfaces (APIs), and macros, visit the SAP BusinessObjects Analysis for Microsoft Office user guide at http://help.sap.com/businessobject/product_guides/AMicrosoft23/en/23SP2_analysisplugin_user_en.pdf.

By incorporating formulas and APIs into your analysis view, you can transform your queries into self-contained applications that are customized to meet your informational, analytical, and formatting needs. In these example scenarios, I show how to use both SAP BusinessObjects Analysis for Microsoft Office formulas and API libraries. These methods help you unleash the latent power of these libraries.

Getting Started

Once the SAP BusinessObjects Analysis for Microsoft Office application has been launched and the familiar Excel spreadsheet interface opens, go to the Formulas tab.

Anurag Barua

Anurag Barua is a principal at TruQua Enterprises. He has 23 years of experience in conceiving, designing, managing, and implementing complex software solutions, including nearly 18 years of experience with SAP applications. He has been associated with several SAP implementations in various capacities. His core SAP competencies include FI and Controlling (FI/CO), logistics, SAP HANA, SAP BW, SAP BusinessObjects, Enterprise Performance Management, SAP Solution Manager, Governance, Risk, and Compliance (GRC), and project management. He is a frequent speaker at SAPinsider conferences and contributes to several publications. He holds a BS in computer science and an MBA in finance. He is a PMI-certified PMP, a Certified Scrum Master (CSM), and is ITIL V3F certified. 

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.