unable to use web services

[Former Member]

Hi,

I am unable to web services in Xcelsius 2008. here is what i did

1. created a web service against efashion universe using Query as web service

2. started Xcelsius then data>connection>Add-->Query as web service

3. entered WSDL for my efashion WS and hit Import.

4. i can see different output parameters (under output values) and mapped to excel cells (through insert in)

but i don't see any data.

am i missing anything ? please help.

thanks

FYI- i am quite new to Xcelsius.

[Former Member · Accepted solution]

Hi Pawan,

From your first post, it looks like you're expecting the data to appear in the Data Manager, which is not exactly how the Query As A Web Service connection works (or any connection for that being).

To see data, configure your Input Values. Since you are using QaaWS, you'll probably need to configure your login and password, along with any parameter value you wish to you to return the proper data.

Also, configure your Output Values by binding them to cells in the Excel sheet. This is where you will see the data that is being returned (Using QaaWS, I typically click on the folder with the blue icon. Once you click on this, the property sheet should tell you specifically how many columns you need to bind to).

Once that is completed, close the Data Manager, add a component to display the data (for example, Spreadsheet Table component), and add a Connection Refresh Button configured to the QaaWS connection.

Preview the model, click on the Refresh Button, enter credentials as needed, and your model should then refresh with data.

FYI - you can also use Refresh on Load (found in QaaWS's Usage properties) instead of the using the Connection Refresh Button.

Hope that helps,

-david

[Former Member · Accepted solution]

Thanks Amr/david,

Now i am getting data tied to my chart. but still i am curious if data becomes visible into excel sheet any point of time?

in other words , is there any way you see data in excel sheet returned by web service?

thanks

[amrsalem1983 · Accepted solution]

you will see it only at the runtime

coz its the only time you request the data from the webservice.

good luck

Amr

[Former Member · Accepted solution]

Thanks Amr. really appreciate your help.

[amrsalem1983]

have you installed service pack 1 for crystal xcelsius?

when you get this webservice from the web browser, you have it work fine?

good luck

Amr

[Former Member]

hello Amr, thanks for reply.

1. no i havn't applied SP1 for xcelsius 2008. ( i just downloaded product from ESD site 2-3 days back)

is it must to install this SP?

2. yes , WSDL URL open fines in browser.

thanks

[amrsalem1983]

i advice you to install the SP1 for Crystal Xcelsius

get it from here

https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/bobj_download/main.htm

then we can follow up the issue

good luck

Amr

[Former Member]

Hi Amr,

as advised i downloaded and installed Sp1 ( first removed old one through add/remove program), but still no luck.

is it possible for you to provide me step by step for getting data from web service?

thanks in advance

[amrsalem1983]

hii

for sure

you can find some info in this link https://boc.sdn.sap.com/node/995

i've made a small example using a famous test Webservice from the internet

- first go to Data manager (data - > Connections )

- Cick the "Add" Button - > then choose "Web Service Connection"

- in the "WSDL URL".. put the URL of ur webservice which will be something like that

http://www.webservicex.com/airport.asmx?WSDL

- Click Import (the button beside the text)

- after you click import it may take some time to collect the functions from the WSDL URL

- at the "Methods" , you will have all the methods available in this webserivce, in case this webservice has more than one Method

- choose the Method you want from the "Methods" List

- you will see the parameters of this methods in two parts (Input Values,Output Values)

- then you can map the input and the out put values in the excel sheet so easy.

- just click any value name , and map it to the excel sheet.

-

---

you will have one more thing - the action -(when the webservice will run)----

---

- Click the "Usage" tab, you will find all the options there.

hope it was helpfull to you

good luck

Amr

[Former Member]

Hi Amr,

I am new to the Xcelsous and downloaded the SP1 and followed your steps to use the Airport web services and I have used the List view to display data. But the List view component displays the XML formatted data and how to get the data only and displayed into the charts or Excel spreadsheet component.

I have passed the airport code IAD to the getAirportInformationByAirportCode method and getting the output like

<NewDataSet> <Table> <AirportCode>IAD</AirportCode> <CityOrAirportName>WASHINGTON DULLES</CityOrAirportName> <Country>United States</Country> <CountryAbbrviation>US</CountryAbbrviation> <CountryCode>32</CountryCode> <GMTOffset>5</GMTOffset> <RunwayLengthFeet>11501</RunwayLengthFeet> .....

Appreciate your help.

[amrsalem1983]

hi there

yes you are right about that, i was just giving this as an example

have you developed your own webservice?