Mapping input values for a web service connection to a range of cells

[Former Member]

I've created a web service connection in Xcelsius data manager. My web service requires an array of integer as input parameter. How do I map input values for a web service connection to read from a range of cells in the spreadsheet, e.g. $A$2:$A$20, in similar way of mapping output values to write to a range of cells in the spreadsheet?

For output values of the web service, I can specify to map the output values to write to a range of cells. However, it doesn't seem to work for reading the input values.

I can map input values for each node to a single cell, e.g. $A$2, in the spreadsheet. However, when I set the "Read From" field to a range of cells, e.g. $A$2:$A$20, it only reads in the first value in the range.

Is there any way that we can do this mapping for input values as we do for output values?

Your assistance is very much appreciated.

Regards,

Van

[former_member186358]

Van,

There is a workaround for that...

Example:

My Webservice accepts input data range in a specific format with " :" symbol, i.e. 072008:082008

Now what i do is

A1 = 072008

A2 = 082008

A3 = CONCATENATE(A1,":",A2)

so A3 = 072008:082008

Now i map the input value in web service to cell A3

P.S have 2 input box components and map it to cells A1 and A2, i.e you are giving users an option to enter the range of values...then web service will capture the range and refreshes data with the range of values user entered.

hope this helps..

-Anil

[former_member186358]

Van,

You may wish to refer the link below..

/people/anil.bavaraju/blog/2009/06/16/xcelsius-and-sap-bi--how-to-pass-variable-value-using-web-service-connection

In this example web service connection is defined in a different way...

-Anil

[Former Member]

Hi Anil,

Thanks very much for very prompt reply.

However, the workarounds that you proposed have not provided complete answer for my question yet.

In your example in "Xcelsius and SAP BI", the input parameter of your web service is an array of 3 elements. So you can easily add 3 items for mapping the input values. My array has the length of 20. I can click on "+" 20 times to add 20 items to map the input values. However, I would like to avoid doing this repetitive exercise. Is there any other way to do it nicely like we do with the output values mapping?

Regards,

Van

[former_member186358]

Van,

There is no option to select multiple values like in output values. Whatever your web service might be, finally the web service connection accepts only one cell. And it is just one time mapping, it is not repetitive...

-Anil