SAP BPC & xP&A Tips, Tricks & News

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

Written by Darko Kavazovic | Wed, Jul 12, 2017 @ 16:07 PM

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.

Resolution

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>
  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

Author 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