cancel
Showing results for 
Search instead for 
Did you mean: 

Issue with universe created on top of a web service

Former Member
0 Kudos

Dear Gurus, I have created a universe based on a web service in IDT (4.1).  I added some SQL code in the field ‘Value’ to return the desired results:

However, when trying to view the result, I get an error message:

Any idea what could be wrong?  I search through the internet but there is little (if none) information on how to build such universes

Thanks for the help. Sébastien

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Victor,

Thank again for your answer.

The number of columns may vary from a few to a lot (+/- 20).

If I understand correctly, since I may not add a full SQL statement there to restrict the output of the generic query behind the web service, we have to create specific web services which will only return the desired fields.  Can you confirm?

Best regards,

Sébastien

Former Member
0 Kudos

Hi Sébastien,

yes exactly, you Need to design specific web Services and not a generic one.

Best regards,

Victor

Former Member
0 Kudos

Hey Victor, One last question: there are 2 protocols for web services: rest & soap.  Can you please confirm that only the rest is supported by IDT? Thanks, Sébastien

Former Member
0 Kudos

Hi Sébastien,

I think only soap as the WSDL needs to be 1.1, but I am not an expert in that.

Did you try with the specific web service and did it work?

Best regards,

Victor

Former Member
0 Kudos

Hi Victor, Took a long time to answer but I was waiting for another team to be able to do further testings...  In the meantime, I can confirm that SOAP is indeed working.  However, the 'structure' of the web service I was originally given was the cause of the error I had.  Also, another issue I have is that the output of the web service was XML.  As a consequence, all fields were returned in one single cell, which is totally useless when I want to create the reports. I saw somewhere however that it is possible to create a web service which return the fields in separated column, not all fields in one cell like the XML output.  Do you know if there is somewhere some guidelines/best practices on how to create web services for BO universes? Thanks! Sébastien

Former Member
0 Kudos

Hi Sébastien,


Also, another issue I have is that the output of the web service was XML.  As a consequence, all fields were returned in one single cell, which is totally useless when I want to create the reports.

I have the same query. do you have any update on that?

Did you changed the Webservice itself or what?

any comment with be helpful here.

Regards,

Nouman

Former Member
0 Kudos

Hello,

check here:

The value of the Parameter in your second screenshot should be a value, not an SQL Statement.

Best regards,

Victor

Former Member
0 Kudos

Hey Victor, Indeed, I saw that blog before posting a message.  My problem is a bit different however.  In my case, the web service is a 'generic' web service (executeGenericQueryIn) calling a generic report in SAP MII.  Since this is a generic report, I have to add some SQL statements to indicate what i want to see as result. When I do so in MII or even SoapUI, I got the expected information.  Not working in IDT however. To refer to the blog you mentioned, I do not have any parameter available. Thank for your time.

Former Member
0 Kudos

Hi Sébastien,

in that case that should not be supported in IDT: How many columns should the Data foundation have? and how many columns of those should be exposed in the Business layer?

So unfortunately for your case in the Input column you can enter a value or IDT-Parameter, but not a whole SQL Statement.

Best regards,

Victor