Skip to Content

This blog is intended to describe the integration of SAP with BO-Xcelsius using web service connectivity. The R/3 or BW data will be consumed as web service so that the service will be used with the data connectivity of Xcelsius. The data gets refreshed every moment based on the user action through the interface where we are going to use SAP BSP as the tool.

The first step is to create the FM, where the logical operation of the report has to perform. We can either use R/3 tables, Classes, methods etc or BW Query as the source. The below steps are explained about how to consume the data through FM as web service.

Create FM “ZSAP_XCEL“, with the following code as shown below.

image

image

image

image

 

Now the FM has to be published as a web service. Follow the below steps which is mentioned in the screens.

image

image

image

 image

image

 

image

  

Once the above steps are done, open the SOA MANAGEMENT through SOAMANAGER transaction and follow the below screens stepwise.

image

image

image

 image

 

We can test the data of the FM as XML file through the web service URL by copying the link which is highlighted above and place it in IE.

image

 

Now the report has to be designed in BO-Xcelsius based on the data from web service which will be consumed as WSDL URL.

image

  

Now the report has to be designed based on the functionality / users requirement of the report. The Input (Read from) and Output (Insert In) cells have to be mapped to the Xcelsius-Excel sheet during the design phase.

image

The designed Xcelsius file will be saved in XLF format locally which will be then exported as SWF file.

image

Now the created SWF file has to be presented to the dashboard by having SAP BSP as the web interface.

Create a BSP Application ZDEMO_WEBSERV with a HTML View-DISPLAY.HTML with the following code. Import the SWF file into the BSP application in the MIME folder.

image

Now test the DISPLAY.HTML and interact with Xcelsius file by giving input and output will be based on the functionality of the web service.

image

 image

 

Here the R/3 data is consumed as a FM and used as the source. In the previous blog also R/3 data is used as the source. BW data can also be used as the source data in the previous and for this blog also.

To report this post you need to login first.

19 Comments

You must be Logged on to comment or reply to a post.

    1. Community User Post author
      Hi,
      Part 1 has the details about the integartion on SAP and Xcelsius using Excels XML Maps connection. Has to do work on that and will be posted ASAP.

      Goks 🙂

      (0) 
  1. William Lawlor
    Hi,
    Great blog. I performed all the steps successfully. However after copying the WSDL URL into IE, I got the error “Service cannot be reached”. It says: “The termination occurred in system DEV with error code 403 and for the reason: Forbidden. The selected virtual host was 0.”
    Is there some authorization or system service which needs starting? I did choose the PRF_DT_IF_SEC_NO option.
    Thanks!
    (0) 
      1. Community User Post author
        Hi William,

        Since it was a weekend I was out from the office 🙂
        Also whenever WSDL comes into the picture, it needs to be activated.

        Thanks,
        Goks 🙂

        (0) 
      1. Patrick Yolabo
        Hi Goks,

        i used the same code as you but it is not working.
        I just changed the SWF name.

        I received this error:”The following error text was processed in the system:
        BSP Exception: the Application Name zdemo_ombre in URL /sap/bc/bsp/sap/zdemo_ombre?sap-client=099 is invalid.”

        Could you help?

        Cheers

        (0) 
        1. Community User Post author
          Hi,

          Could you kindly check the SWF object name and the object used within layout? Try to follow the same objects name (Case sensitive)

          Gokul

          (0) 
  2. William Lawlor
    Hi Goks,
    I have the WS/XC up and running – thank-you! Data is being retrieved based on the value entered into the cells from the user selection.

    However I’m now trying to get the user to select and pass dates from the xcelsius into my function module, and I keep getting “Error #2032” from the SWF. Do you know what could be causing this? I’ve made the input parameters as type string in the function module, and have been trying all formats of the date in the Excel sheet, but no luck.

    Any ideas apprecitaed 🙂 Thanks.

    (0) 
    1. Community User Post author
      Hi William,
      The same problem occurs while I was working with WS connectivity and I forgot what I have did 🙁 Since i was out of office today and tomorrow, I’ll check this soon.
      Anyway kindly do the below:
      While clicking the Refresh Button, keep  the break point in the WS FM and debug it. See whether date selected is parsed in a proper format. Also please dont do any fomatting in the cell you define for the date.

      Regards,
      Gokul.N

      (0) 
    2. Community User Post author
      Hi William,
      Sorry for the late reply and also now only I got connected with my server 🙁
      The error your getting will be resolved by overcoming the below issues:
      Execute the SWF and preview. Dont preview within Xcelsius for the Web Service connection.
      Check with the format of date your parsing to the web service.

      Regards,
      Gokul.N

      (0) 
      1. William Lawlor
        Hi Goks,
        It seems Xcelsius doesn’t like SY-DATUM. I simply changed it to STRING and it gets passed back fine, both in preview and SWF 🙂
        Thanks for your help!

        William

        (0) 
    3. Patrick Yolabo
      Hi William,

      sorry for disturbing you. i followed all steps in this block successfully till:
      Designing and Configuring Xcelsius file Using Created Web Service as the Source.

      My problem now is the report which has to be designed in BO-Xcelsius based on the data from web WSDL URL.
      How have you done the connection to excelsheet? Please indicate steps by steps how you connect data from the data manager in Xcelsius to the sheet and how to proceed with Spreadsheet, List Box, Column Chart, and Refresh Button.

      Thank you so much for you help.
      gilo@gmx.net

      Cheers

      (0) 
  3. Tanuj Bolisetty
    Hi,

    As the hosname and port are staic and are embedded in swf , when the bsp application hosting the swf is transported to QA system it still uses the DEV hostname and port which is present in the swf.

    So if we can make it dynamic and pass the values at runtime , the bsp application will connect to the webservice on the corresponding server.

    Will falsh variables help for this scenario

    Thanks,
    Tanuj

    (0) 

Leave a Reply