Skip to Content

Excel Add-In for APO Demand Planning

We recently upgraded our SCM landscape to SCM7 EhP3, and want to start testing the APO Demand Planning Add-In for Excel.  I've followed the Installation & Configuration Guide, but can't get a connection from Excel back to our APO system.  I've verified that the sap/scmapo/rest/epm/demand_plan_srv is active in SICF.  I've also verified the host and port settings.  One interesting thing I have noticed is the the 'test service' function in sicf fails for the demand_plan_srv service - is this normal?  When I try to create the Excel > APO connection, the only error I get is a generic "EPM Connection Failed" popup box, with no additional details.

Has anyone else had any success in using the Excel Add-In with SCM7 EhP3?

Thanks,

John

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

7 Answers

  • avatar image
    Former Member
    Jan 09, 2015 at 03:48 PM

    Hello John,

    I have the same issue as yours. Seems that the SICF service has some issues. In any case we should no receive the bad connection as service is reachable by http. Something goes wrong with the functionality I suppose....

    Thanks

    Simos and Stephan H.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 30, 2015 at 02:30 PM

    Hello John,

    some weeks ago we upgraded our playground system to the lastest version SCM7 EhP3 to start testing the APO Demand Planning Add-In for Excel.

    In the beginning we faced some minor problems with the connection but now it works.

    He had some minor issues with the error "InfoObject 0TCAACTVT does not exist in version A (termination: RABAX_STATE)" and we had to define at least one active planning area and planning book
    .

    Regards

    Peter

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 11, 2015 at 12:43 PM

    Hello,

    please, check if SAP Note  2096807 is applicable to your system as per SP level.

    I believe that this should solve this connection problem.

    Thanks and best regards,

    Douglas Oliveira

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 13, 2015 at 04:14 AM

    We got it to work in a later support pack in EP2 ie SAPKY70212

    One of the keys for us was to make sure we followed the order/sequence in the guide.

    ie I tried to load the software on a laptop before we had the latest pack and that laptop never worked.

    But after upgrading to this support pack and setting up all the settings within APO via the guide, and THEN loading the software onto the laptop (a differnet laptop!) then it worked.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member john elder

      John,

              Thank you very much. I have another question. I am able to add comments on excel but somehow the comments are not making it to APO DP, do I need to configure anything?

      Hassan

  • avatar image
    Former Member
    Feb 26, 2015 at 06:48 AM

    Hello John,

    To use this functionality minimum requirement is  SAP SCM 7.0 EHP 3 SP04. So please check your SP Number.

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 05, 2015 at 05:43 PM

    We're finally able to connect from the Add-In back to our SCM7 EhP3 system, and can 'see' the planning books and versions, and are able to select the one we want to test with.  Unfortunately, nothing seems to be downloaded from APO to Excel.  What are we missing here - shouldn't this be fairly simple?

    John L

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 09, 2015 at 09:11 PM

    Hi,

    you should be aware there still lots of bugs using the excel, we are testing it for 3 months, and already SAP created 2 notes as  a results of our incidents, and there is still 1 more to come, from what i understand a new version should be release, hopefully with less bugs.

    when it will be stable it looks very good tool.

    Add comment
    10|10000 characters needed characters exceeded