Man-Computer-Laptop-Coffee-Cafe-Concept-000079551979_Large-1.jpg

SAP BPC & EPM
Thought Leadership

VBA Object Declarations in the EPM Plug-In for Analysis for Office

Posted by Dennis Frey on Fri, Nov 03, 2017 @ 09:11 AM

One of the key features for the SAP BPC EPM Add-in for Excel has been the ability to write VBA to extend and customize the capabilities of the Add-in. The new EPM Plug-in for Analysis for Office (AO), which replaces the EPM Add-in, offers similar and in most cases compatible VBA support as the original EPM Add-in. However, there are some important distinctions between the two which this article covers.

The new EPM Plug-in for Analysis for Office (AO) requires a different method of declaring the specific API class used to access the library of VBA methods that SAP BPC supports.  The latest version as of this writing, AO 2.4 SP1, made some but not all the old FPMXL Client methods compatible with the EPM Plug-in.  To be safe, it’s recommended to start coding using the new standards for AO, as there’s no clear indication of whether all methods will be made compatible using the old object declaration standards.

To illustrate, here is a direct comparison of the differences between the two declaration methods.

Topics: Analysis Office, API, EPM Add-in, EPM

Analysis for Office and the BPC Plug-in – everything you need to know!

Posted by Adam Hess on Wed, Apr 05, 2017 @ 09:04 AM

Long term BPC customers know that one of the tool’s key strengths, its powerful and easy to use reporting  interface, can also be a challenge at inconvenient times. Over
the history of BPC’s reporting interface, dating back to OutlookSoft with venerable EvGet functions, relatively few changes have been made to the system.

Topics: BPC, Analysis Office

EPM vs Analysis Office

Posted by Richard Hynes on Tue, May 24, 2016 @ 15:05 PM

Many of you will have heard that the EPM Add-In is being replaced with Analysis Office. This is not quite true: the EPM Add-In is being replaced by the EPM Plug-In which is a part of the new Analysis Office Add-In which also contains a Plug-In called Analysis. I hope that is clear.

If not, let me explain further.

Topics: Enterprise Performance Management (EPM), EPM 10, EPM Landscape, Analysis Office

Subscribe

Recent Posts