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

SAP Analytics
Thought Leadership

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

Posted by
Darko Kavazovic
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.

Featured Blog Photo-1.pngProblem

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.



To correct this issue, we must change EPM Add-in parameters as follows:

  1. Close any open Excel files
  2. Locate XML file and open in notepad. (in C:\Users\<YourID>\AppData\Local\EPMOfficeClient)
  3. At very bottom of file change key <ForceDoNotStoreConnection>false</ForceDoNotStoreConnection> to <ForceDoNotStoreConnection>true</ForceDoNotStoreConnection>2-2.png
  4. Save the file
  5. Restart Excel and test again to open your template

SAP has been notified of this issue and we hope that they will implement a fix in the next release of the EPM Add-in.

Did you know that an Extended Support customer, you receive up to date alerts such as this as they happen? Contact us today to find out more about the different Extended Support options to assist with the technical support of your SAP BPC system! We also hold quarterly Technical Administration Training for both BPC Netweaver and Microsoft - check out this page for the dates and details of upcoming sessions!

Related Articles:

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

SAP BW-IP, SAP BPC NW 10.1 Standard and SAP BPC NW 10.1 Embedded Compared

Troubleshooting Techniques for SAP BPC Reports Created w/ the EPM Add-in

5 Things You Can Do to Get the Best Performance from Your BPC MS 10/10.1 Server Environment, Part 2

Darko-1.pngAuthor Bio:

Darko Kavazovic has been a technical consultant for Column5 for almost 3 years. He has a wide range of experiences in development and delivery of SAP BI technologies. He speaks 3+ different languages and has exceptional understanding of SAP products. Before coming to Column5, he worked for Sysco Corp. with their SAP administration. 

Darko Kavazovic, Technical Consultant, Column5 Consulting US team

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


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  


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