WEBi Report on WEB SERVICES Data Source

[Former Member]

We are using BE XI 3.1 SP2. We are trying to create a WEBi document based on WEB services. We have consumed this web service through ASP.NET and viewed the output.just to make sure it's working. Now, If I give the same web service URL it fails with this error message:

Error from Personal Datasource: Unable to create or update the Custom Data Provider: the provided URL is not valid (CDS 105119). (WIS 10853)

I tried searching it through google..but no help found anywhere..

Any Ideas?

Thanks,

[Former Member · Accepted solution]

Hi Srikanth,

WebIntelligence web service data provider is constrained to some WebI generated WSDL, and is currently not supporting other web service providers.

It can only parse WSDL from QaaWS (query as web service) or BI Service (WebI blocks exposed as we services).

This is the explanation why it cannot parse your own WSDL.

Hope that helps,

David.

[Former Member · Accepted solution]

Thanks for the reply. that explains why I could use that web serive in CR Xi but not in WEBi..

[Former Member · Accepted solution]

Hi David /Henry or any geek,

Can you please advise ?

Business requirement: To create webintelligence report on Issue tracker data stored in ttp://jetbrains.com/

Options

1) We are using SAP BI 4.1 sp2 We are trying to create a WEBI Rich document based on WEB services from http://jetbrains.com/ We have consumed this web service through scripting (python) and viewed the output.just to make sure it's working. Now, If I give the same web service URL it fails with this error message in WEBI Rich document using Customer data provider:

Error from Personal Datasource: Unable to create or update the Custom Data Provider: the provided URL is not valid (CDS 105119). (WIS 10853)

2) Even http://jetbrains.com/   exposes their Jet brains Restful API to get data,

Is there any way Jet brains Restful API can talk to webintelligence restful API  and get data to create webi report

3) Work around available by A) exporting manually all issues from ttp://jetbrains.com/ in to excel and B) add excel document in IFRS and C) create webi report using the excel document in (IFRS) and D) manually replace the excel file with new copy every month before refreshing the webi report  

Tried searching it through google..but no help found anywhere..Any Ideas to automate ?

Appreciate your help in advance

Regards,

Venu.K

SAP Technical Architect

National Grid UK

[Former Member]

DO you know if BO 4.0 SP 2 patch 11 allows to parse other web services than WSDL from QaaWS or BI Service?

Thanks Michael

.

[Henry_Banks]

Hi,

I believe you can consume NW web services, but not other 'sap' WS like CRM for example.

Regards,

H

[former_member182616]

Henry,

We have this initial response on our OSS. Do you agree with it?

the information I found coming from Product Group states that Web

Intelligence Rich Client only supports the use of two kinds of Web

Services as data source:

- It can only parse WSDL from QaaWS (query as web service) or BI

Service (WebI blocks exposed as web services).

- It doesn't support web services from any other source, therefore it

will not be able to parse an ABAP web service.

If this statement doesn#t match what you are trying to achieve and you

are indeed trying to consume either WSDL from QaaWS or a BI service,

then please let me know and we can organise a SAP Connect meeting to

explore this issue further.

However, if you are indeed trying to consume an ABAP Web Service in

Webi Rich Client, then I#m sorry to say, as above, that this is not

currently supported in BI 4.0.

Thx,

MD

[Henry_Banks]

100% agree, and this is what the Product Group Manager (mr bunner) originally asserts above.

I'm faily sure the NW WS is consumable in Dashboard Design (previously Xcelsius) but not webi.

Regards

H