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