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

[Former Member]

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)

[Former Member]

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)

[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-e00532e6...

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