Skip to Content
avatar image
Former Member

Publishing and Consuming Query Webservice - Query_View_Data

Hi Experts,

I have set up "Query_View_Data" taking reference from Weblog

/people/prakash.darji/blog/2006/09/04/work-with-xmla-web-service-for-bi-data-in-external-applications --> Document : Web Services within SAP NetWeaver 2004s BI - Create, Discover, and Consume! --> Page Nos. 26 to 42.

I am able to test my Query Webservice from my BW system using transaction WSADMIN & the Request as well as Response are successful.

Now I am trying to create a Visual Composer - iView.

In this iView, I am trying to define the webservice (Tools --> Define Webservice).

The URL which I enter for the webservice is :

http://<Server>:<Port>/sap/bw/xml/soap/queryview?wsdl

Port I am using same as my VC / EP Port.

I am getting an Error Message : Invalid Webservice URL

Am I missing anything ?

Please suggest.

Thanks and regards - Rajesh Sarin (09987014089)

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Oct 12, 2007 at 05:38 AM

    Hi,

    I am trying to use "GetQueryViewData" Method to consume my BI Query Data as a Webservice within a VC Model.

    Refering to my earlier post, we did the Port Settings in Visual Administrator for the WS URL : http://<server>:<port>/sap/bc/srt/rfc/sap/QUERY_VIEW_DATA?sap-client=100&wsdl=1.1

    After this in Visual Composer Model, I am trying to create an iView and then now I am able to find the BI Query "GetQueryViewData" WebService in "Find Data Services".

    But when I drag this "GetQueryViewData" webservice to VC iView, I get an error message :

    ===========================================================

    Failed to Fetch MetaData : Portal Request Failed due to : Cannot Import the selected operation. Mandatory Port AxisData includes nested tables which are not presently supported by Visual Composer.

    ===========================================================

    For this Webservice using Method "GetQueryViewData", when it is executed, would ask for the Input Parameters - InfoProvider, Query, ViewId, Parameter and then it gives the result of the BI Query with Output Parameters as AxisData, AxisInfo, CellData, TextSymbols.

    Question : Can we Model in Visual Composer using Webservice - "GetQueryViewData" Method ?

    Thanks a lot for the time / help extended, in advance.

    regards,

    Rajesh Sarin (+91-9987014089)

    Add comment
    10|10000 characters needed characters exceeded