<img src="https://certify.alexametrics.com/atrk.gif?account=3HHNq1DlQy20Y8" style="display:none" height="1" width="1" alt="">
iStock-955408614

SAP Analytics
Thought Leadership

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

Posted by Steve Sussman on Wed, Jul 10, 2024 @ 08:07 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

Waltzing with Columns in the EPM Add-in for SAP BPC

Posted by Deb Silverman on Wed, Jan 17, 2018 @ 08:01 AM

We all encounter game-changing challenges, so here’s my story of how a simple task we do every day has taught me that things are not always as easy as they seem. 

When using overrides with rows, the column keys sometimes shift around.  We all have our strategies, however I discovered an issue with an EPM tab containing multiple reports (000, 001, 002 +...) not sharing a column axis. Typically, local members are positioned or anchored and methodically built with the expectation they’ll stick.  I hit a wall and was lucky a colleague was sitting nearby to share ideas on how to fix this issue. 

Topics: Product Focused, EPM Add-in

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

Subscribe

Recent Posts

Posts by Topic

see all

3  S T E P S

To Enhance Your EPM Performance:

 1.Get Your Ultimate Guide to Improving SAP EPM Performance

ebook 2

 Learn what could be contributing to your poor performance and how to diagnose common problems. Get tips that will empower you and your team to improve the  performance  of your system in order to get the most out of your SAP EPM Investment.

Get the e-Book

 

2.  Test Your BPC Performance 

Benchmark 2

Get a BPC performance report card and custom report to identify performance issues you may not even know you have.

Test my BPC

 

  3. Get Your EPM Assessment  

Assessment

Our assessment delivers a complete, best practice roadmap for you to follow.  We’ll work together to assess what you need to pivot your financial forecasting, planning, reporting and analysis to handle the compressed requirements from the volatile COVID-19 environment. 

New Assessment