Skip to Content
avatar image
Former Member

BCP 10.1 NW and Analysis for MS Excel or Live Office

Dear Experts,

Do you have any experience with using BPC 10.1 NW with Analysis for MS Excel or Live Office?

Before upgrade from BPC 7.5 NW we were successfully using Live Office to deliver data form BEx Queries to our BPC Input Form. Now we work with BPC 10.1 NW and both add-ins Live Office and Analysis seems to work unstable.

I am able to create a report using both tools but after I save it on BPC server and reopen it is not recognized as a Live Office / Analysis object. Everything is MS Ribbon is greyed out.

analysis3.jpg

analysis4.jpg

We are using following sowfrawe versions:

Live Office Version: 14.0.12.1946 ; Build: 1946

Analysis for MS Excel 51051633 SBOP Analysis 2.4

EPM MS Office add-in Version: 10.0 SP 26 Patch 2 .NET4;build 9606

analysis3.jpg (242.4 kB)
analysis4.jpg (243.7 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Feb 16, 2017 at 01:14 PM

    Hi Jakub,

    If you are using BPC Standard then please use EPM Add-in in standalone mode! No need to use Analysis for Office.......AFO is required in case of BPC Embedded!

    Look here https://blogs.sap.com/2016/12/07/bpc-10.1-office-client-strategy/

    With my personal experience....if you download AFO then you cant install EPM Addin separately! It comes as part of AFO as a plug in.

    Regards,

    JP

    Add comment
    10|10000 characters needed characters exceeded