Skip to Content
avatar image
Former Member

"GetQueryViewData" Method , BI Query Data as a Webservice within VC Model

Hi,

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

I have done the needed settings in BW and 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 I find the "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

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Oct 17, 2007 at 04:55 AM

    Hi Experts,

    I am trying to Publish the BI Query as a Webservice (using "GetQueryViewData" Method) and then Consume this Webservice in a Visual Composer Model.

    But when I try to consume this webservice to a Visual Composer 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.

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

    Can you please suggest.

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

    regards,

    Rajesh Sarin (+91-9987014089)

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Experts,

      In one of the SDN Articles - “Consuming a BI Web Service via the Portal – a Practical Application”, link :

      https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/6c94707f-0d01-0010-c199-e00532e671f3

      Page 42 of this article for VC (SP8) mentions :

      • If the nested table is a mandatory field – the operation can not be used (error

      message)

      • If the nested table is an optional field – the table will be omitted (warning

      message)

      In case of BI WebService, we do encounter Mandatory Nested Tables (Fact - Dimension - SID - Master Data) and BI Queries would be using these Nested Tables.

      Does that mean - VC cannot handle BI Web Service ?

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

      (Surely I do understand that if both BW and VC/EP are owned by the same company direct BI Connection is the best way. But, I am trying this approach with an assumption that my BW WebService is consumed by a Third Party VC / EP to whom I am allowing limited access, and donot want him to have a direct BI Connection.)

      regards,

      Rajesh Sarin