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 :


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


    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.


    Rajesh Sarin (+91-9987014089)

    Add comment
    10|10000 characters needed characters exceeded