Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Multiple connections via xml maps

I am currently using Engage SP1 version of Xcelsius. (not Engage Server.)

As noted in other posts, this version of the product does not all allow multiple connections to web services using the connectivity tools built into the Xcelsius development environment.

However I've found there is no such limit placed on the number of web service connections if you set them up in Excel (as xml mappings) and then import that excel spreadsheet as the model for Xcelsius.

I've tested this by connecting to three different web services using 3 xml maps in Excel and then importing that excel file as the model for Xcelsius to use. The xcelsius model worked flawlessly displaying data from all three web services on the dashboard (swf).

The only limitation I've found is that the excel XML mapping tool doesn't offer a way to feed a value as input for the web service. In the example all three web services required no input values.

They just run when called and return data. (no parameter required.)

However my attempts to setup an xml mapping to a web service that requires an input parameter has failed.

There seems to be no way to feed the web service an input value within Excel. I realize that may be an Excel support issue, but have found no documentation in the Excel product or websites to explain how to setup the xml map to allow for the input.

I should note, that i have connected successfully using a web service url that contains the parameter values hard coded (but no successess passing them in from excel at the time of the web service call.)

If anyone has solved this issue any feedback would be greatly appreciated.

Edited by: Blake Dodds on Oct 3, 2008 5:38 PM

Not what you were looking for? View more on this topic or Ask a question