Expose BI data

[Former Member]

BI Experts,

Can we expose BI data as web service. My scenario is that I want to pull data from BI into MS SQL. I know I can use Open hub, but can we use web services?....like expose a cube data...etc?

Thanks

Ashwin

[Former Member]

Also I found this how to paper. The thing has anybody done this before

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/7ffba2ec-0c01-0010-2e81-988...

[Former Member]

Thanks Bhanu,

Well what i need to achieve is on demand data from BI. I am trying to intiate a pull from SQL and the data set selection happens there. I want to ( but not sure if possible) be able to select data from a SQL statement on SQL side and pull data from BI. Do you know if that would be possible using web services or a RFC or a BAPI?

And it was a pleasure to meet you in Tech Ed. Finally got to meet the person who has contributed so much to the community. Thanks.

Ashwin

[former_member188975]

Hi Ashwin,

It is possible to access the query data through a web service. Check here for more info:

http://help.sap.com/saphelp_nw04/helpdata/en/d8/3bfc3f8fc2c542e10000000a1550b0/content.htm

Hope this helps...

(p.s. It was nice to meet you at the TechEd