Webservices in BI 7.0

[Former Member]

Hi,

We are planning to use web services in BI 7.0 to report data to external system. We activated Web services and create Query in BW and used Query_View method to export data out of BW. The output XML going out of BW is very generic and we want to control the contents of XML generated. How can i customize the output format of the XML which is sent out of BW? Can we create our own template?

Are there other web service methods which i can use and control the output format of the XML? would be great help..please suggest

Surya

[avishek_gorai2]

Hi Surya,

Unfortunately we could not find any way to limit/customize the data returned by this Web Service (which I admit is very confusing), also we could not find any other Web Service to retrive Queries from BI, so we created our own Service using the RFC RRW3_GET_QUERY_VIEW_DATA (on which this service is alos based) by sending only the required data through the custom Service implemntation.

You can alos consider RESTful services discussed in the following blog and customize the Web dynpro program for a desired output:

http://wiki.sdn.sap.com/wiki/display/BI/ExposeBIQueryasRESTful+Service

Regards,

Avishek.

[Former Member]

Hi,

you can use SAP BW Data Access Builder.

Go through below help files

.http://help.sap.com/saphelp_nw70/helpdata/en/80/1a63b3e07211d2acb80000e829fbfe/frameset.htm

http://www.tli-usa.com/download/XMLDataLoadsatGrainger.pdf

Regards

Nagarju