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

[TECH ALERT] BPC 10.x Microsoft with EPM Add-in SP29

Posted by Darko Kavazovic on Wed, Jul 12, 2017 @ 09:07 AM

Our Technical Services team has received an influx of service tickets regarding issues with the recently released SAP BPC EPM Add-in Service Pack 29.

Problem

With EPM Add-in SP29 installed, we noticed that none of the built-in reports or report templates are working when trying to refresh with BPC 10.1 Microsoft (MS). When attempting to refresh, it keeps prompting to login to SAP NetWeaver (NW) system, instead of BPC 10.1 Microsoft.  Please see example below:

ldcie3f.wdf.sap.corp EPMAddin_ODBOSP3 Consolidation

We are connected to the Planning model for BPC MS but it is trying to login to BPC NW Consolidation.

Topics: BPC (Business Planning & Consolidation), BPC, Services Focused, Technical, EPM Add-in, EPM

6 Commonly Asked Questions About the EPM Add-in Excel Client

Posted by Darko Kavazovic on Fri, Sep 09, 2016 @ 10:09 AM

The EPM Add-in client is a hot topic among our customers and a subject we receive plenty of questions about. Questions usually arise during migration from the SAP BusinessObjects Planning and Consolidation (BPC) 7.x version for the Microsoft platform to SAP BPC 10.0 or 10.1, version for the Microsoft platform. This blog will cover questions about the EPM Add-in client during system upgrades. 

Topics: Excel, Technical, EPM Add-in

Subscribe

Recent Posts