SAP Knowledge Base Article - Public

1426346 - Not able to connect Xcelsius using web service connections/links based on multiple schema

Symptom

When we create Xcelsius dashboard using Web Service links i.e. WSDL links created using SOAP shows up with only 1 input variable while when we test it outside of Xcelsius it works fine.

Environment

  • Xcelsius 2008 Service Pack 2
  • Xcelsius 2008 Service Pack 3

Reproducing the Issue

1. Create Xcelsius file
2. Add a data connection: Web Service Connection
3. Import WSDL http://sametime.changetocomm.nl/testws.nsf/TEST?WSDL

  • Example:
    A WSDL file published at:
    http://sametime.changetocomm.nl/testws.nsf/TEST?WSDL

    This WSDL has 3 input variabels:
    - TESTRESULT
    - AUTHENTICATIONSTRING
    - KEY
  • The Output is PASSTESTRESULTReturn .

    The value for the AUTHENTICATIONSTRING for a positive return string is:
    iejfw32434fsar@#23DSFEW%GFT$54325t4t5cdop322323iuhskvu-
    092398yiuaiejfw32434fsar@#23DSFEW%GFT$54325t4t5cdop322323iuhskvu-
    092398yiua
    Only 1 input value is shown instead of 3.

Cause

Xcelsisus support only single schema web service. Web service created from PHP script, SQL 2005 or SOAP are based on multiple schemas.

Resolution

Create single schema web services which are supported in Xcelsius. Create web service using Query as web service.

See Also

1240174 - Error: "Unable to Load URL" when trying to add a Web Service Connection based on multiple schema in Xcelsius

Keywords

Xcelsius, web service, SOAP, SOAP web service, PHP script , KBA , BI-RA-XL , Dashboards and Presentation Design , Problem

Product

SAP BusinessObjects Xcelsius Enterprise 2008