SAP EPM 10.0 Add-In: Not Just Your Basic Excel Spreadsheet Any More

  • by Peter Jones, BI Solution Architect, M16 Solutions
  • May 29, 2012
See the added functionality that comes with the SAP Enterprise Performance Management 10.0 Add-In for Excel. Learn how you can use the Add-In to enhance your SAP NetWeaver BW and SAP BusinessObjects BI reports.
Key Concept

You can find enhanced reporting capabilities within the new functionality and features in the SAP Enterprise Performance Management (EPM) 10.0 Add-In interface. These enhancements include, but are not limited to, refresh features and connection options to InfoCubes in SAP NetWeaver BW and SAP Planning and Consolidation. The Microsoft Excel interface of the EPM 10.0 Add-In is a key entry point for reporting on all components within this suite, as well as basic SAP NetWeaver BW InfoCubes. 

The ramp-up process for SAP Enterprise Performance Management (EPM) 10.0 is underway. All the components in that suite are either moving forward with ramp-up companies or have recently moved out of ramp-up to general availability. One of the significant areas to change in this version is the user interface (UI) that goes across the entire suite of products.   

Each of the toolsets for EPM products in the past has had its own UI, but with version 10.0, that approach has changed. There are reporting options within each of the products that are inherent to the specific component, but the focus is on using the Microsoft Excel interface of the EPM 10.0 Add-In for reporting on all components within this suite. The Add-In is incorporated into the EPM 10.0 suite of products and is the primary UI for version 10.0. If your focus is SAP Planning and Consolidation (BPC), then this UI is required for reporting and input functionality as well as for direct access to the Data Manager portion to execute BPC-specific activities.

One of the by-products of the EPM 10.0 reporting component is that it not only supports the EPM products — including the Microsoft and SAP NetWeaver versions of BPC, Strategy Management, Profitability and Cost Management, and Financial Information Management — but it also can work with the core BI InfoProviders in SAP NetWeaver BW.

From a reporting point of view, you now have to include the EPM 10.0 Add-In in the mix of all the components to choose for reporting. Will it be Crystal Reports, Analyzer, Web Intelligence, Dashboard Designer, BEx Analyzer, BEx Web Analyzer, or Business Explorer? Even though the Analyzer and BEx Analyzer support the use of the Excel component of the Microsoft Office suite, the EPM Add-In separates itself from the rest in a number of ways.

The core functionality of the Excel interface of the EPM Add-In is about as close to a native Excel spreadsheet as you can get. If you compare the three Excel-based reporting components (BEx Analyzer, Analytics, and EPM Add-In) based on their Excel functionality, I believe the EPM Add-In comes out on top.  

Peter Jones

Peter Jones is a business intelligence solution architect in the areas of CO, EC, SAP BW, BI, BusinessObjects, Planning and Consolidation (BPC), and SEM for MI6 Solutions. He is certified in all these areas and is a subject-material expert for SEM, CO, BI, and BPC, with over 14 years of experience in these areas working for SAP and MI6 Solutions. Currently, he is involved in projects incorporating SAP BW 7.4, HANA, BPC 10.0, and EPM 10.0. He has consulted in all those areas for the last nine years. Peter was an SAP instructor for seven years and has written several books about SAP NetWeaver BW, FI/CO, and has recently revised his book about BPC Implementation to version 10.1. He is a contributor to Best Practices for Financial Reporting in SAP, an exclusive anthology of articles that delivers unparalleled guidance on how to optimize financial reporting processes with SAP applications.

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.