Problems with consuming SAP BW WSDL in Crystal Reports 2008

[Former Member]

Hello,

I am trying to use the WSDL generated from the SAP BW in Crystal Reports 2008 using the XML and Web Services driver, but when I input the WSDL url Crystal does not interpret the url passed in as a WSDL url and the Services, Port and Method drop downs are blank.

If I manually input the values I get the error below from Crystal

"Logon failed.

Details: Web Service Location is invalid

WSDL Exception (at /wsdl:definitions/wsdl:portType/wsp:Policy): faultCode=INVALID_WSDL:Encountered unexpected element

'Policy'."

I know this is a valid WSDL as I have tested it with Xcelsius 2008 and I am able to get data back in Xcelsius. I found SAP note 1485601 that talks about Crystal Reports not being able to reading a WSDL generated by a SAP system.

https://websmp230.sap-ag.de/sap/support/notes/1485601

Based on the error message from Crystal above I feel that Crystal is unable to read the WSDL URL, has anyone else encountered this issue, if so is there a possible work around.

We are running Crystal Reports 2008 V1 SP3 FP 3 and the SAP Integration Kit is also on the same service pack and patch level.

Any help or insight into the issue will be very helpful.

Thanks,

Kumar

[IngoH · Accepted solution]

Hi,

which connectivity are you referring to and why not using the standard BW connectivity from Crystal Reports for BW ?

Ingo

[Former Member · Accepted solution]

Ingo,

I am using the "XML and Web Services" connection option in Crystal Reports, and using a HTTP WSDL.Here is a sample of how WSDL url generated by SAP BW.

http://servername:8000/sap/bc/srt/wsdl/bndg_DF6E553E117931F19C6B001560A1B616/wsdl11/allinone/ws_poli...

We have a two structure BW query (one for keyfigures and one as characteristic structure ), I know that this will cause the structure for the characteristics to show up as a single field and each element of the structure will result in a row of data, but we need the individual elements on the structure and we were hoping to get around the MDX driver limitation by using the web service connection.

The data in the Crystal Reports 2008 needs to be in a crosstab layout as shown below, but if we use the Crosstab expert the key figures are stacked one under the other and also we cannot get the labels from the KPI structure to show up on the Crystal Reports.

Characteristic Structure

Column1 Column2 Column3

Label 1 KeyFigure 1 KeyFigure 2 KeyFigure 3

Label 2 KeyFigure 1 KeyFigure 2 KeyFigure 3

Label 3 KeyFigure 1 KeyFigure 2 KeyFigure 3

This layout is already built in a Web Template and therefore we were planning on using the WSDL to get the layout directly into Crystal report, but I keep running into the WSDL error when I try to consume the WSDL in Crystal.

Thanks,

Kumar

[IngoH · Accepted solution]

Hi,

the web service connection is not part of the integration Kit and looks like a custom development here.

What I would suggest is that you actually use the standard BW driver for Crystal Reports 2008.

ingo

[Former Member · Accepted solution]

Hello Ingo,

By standard driver if you mean the MDX driver, I can use the MDX driver but I cannot format the data as per my report requirements noted above, but if I use the old BW driver it would not work as the BEx query has two structures.

My question is whether the "XML and Web Services" connection can consume the WSDL generated by SAP BEx query or not?

I have been able to successfully consume BO's Query as a Web Service (QaaWS) WSDL without any issues but cannot use the WSDL generated by SAP.

Thanks,

Kumar

[former_member11696]

Moved to SAP Integration kit forum