Question Re: WEBi Report on WEB SERVICES Data Source in Technology Q&A

WEBi Report on WEB SERVICES Data Source

Former Member — Tue, 26 Apr 2011 18:31:36 GMT

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,

Re: WEBi Report on WEB SERVICES Data Source

Former Member — Wed, 27 Apr 2011 15:59:55 GMT

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.

Re: WEBi Report on WEB SERVICES Data Source

Former Member — Thu, 28 Apr 2011 21:35:30 GMT

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

Re: WEBi Report on WEB SERVICES Data Source

Former Member — Fri, 10 Feb 2012 13:56:21 GMT

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

Re: WEBi Report on WEB SERVICES Data Source

Henry_Banks — Fri, 10 Feb 2012 14:04:53 GMT

Hi,

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

Regards,

Re: WEBi Report on WEB SERVICES Data Source

former_member182616 — Mon, 20 Feb 2012 09:17:25 GMT

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,

Re: WEBi Report on WEB SERVICES Data Source

Henry_Banks — Tue, 21 Feb 2012 12:39:58 GMT

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

Re: WEBi Report on WEB SERVICES Data Source

Former Member — Thu, 15 Jan 2015 14:00:49 GMT

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