tRequestHeader "Content-Type", "text/xml" 'We use this code snippet to invoke a web service that doesn't require any user authentication 'ObjHTTP.Open "Post", sURL, False, "username", "password" 'use this code snippet to invoke a web service which requires authentication SURL = " ' we create our SOAP envelope for submission to the Web Service ' Code Snippets : Some of the source code listed below was taken from the following websites and credit show be given to the respective authors This object is part of the Microsoft XML 6.0 library which is a pre-requisite for the EPM Add-In and should be installed on all client machines. VBA Code example : This is a simply Sub Routine in which will invoke a web service using the MSXML2 Object. It is possible to invoke a REST Web Service which BPC 10 uses, I will do this in another blog detailing a scenario in which this code could be used to solve certain business requirements. This VBA code is used to call a SOAP Web Service. If you are able to get the WSDL of the Web Service, you can build your SOAP message and invoke the web service to perform the desired function. Export data of BPC into another EPM application but simply invoking a web service to create a KPI in SSM.Invoking a BPC web service to perform a specific action.Invoking a FIM job from a click of a button on a report or input schedule.Now there are several tutorials and links out on the internet which give you sample code to invoke a Web Service using VBA, but one of the major reasons for writing this blog is is to show how this approach can be used to solve several challenges and how powerful it can be. The answer to my particular challenge was to invoke a Web Service using custom VBA code embedded in an BPC Input Schedule and Report. Because SAP BPC uses Microsoft Office, you can create custom macros and VBA code to execute specific functions and functionality. So the solution was to invoke it from the client machine using VBA because on the client machine it can invoke any web service. Now there is several methods to invoke a web service from BPC NW, but it wouldnt be transportable to the MS product. I needed to invoke a web service for an EPM product but had to do it in SAP BPC NW. The great thing with SAP EPM products is that there are web services for major processes and functions that need to be performed. Initially it was quite challenging because as with any integration project the devil is always in the detail. Recently I have been involved with several integration projects between different EPM products.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2023
Categories |