Skip to main content
Announcements
A fresh, new look for the Data Integration & Quality forums and navigation! Read more about what's changed.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

SAP Bex Web connection

Dear community 
Looking to connect to a SAP BW instance via its Netweaver Web interface.
Do I use a HTTP call, or how to manage a SAP Web BI report? Can I submit variable selection parameters from the job and start the query automated?
The report has an entry selection screen, then an output screen with result to be parsed?? Or is there a direct connector to the web interface?
=>
Labels (2)
14 Replies
Anonymous
Not applicable
Author

Hmm, cannot see my screenshots?
test to upload again
Anonymous
Not applicable
Author

We don't support the BEX interface. We have dedicated components though to interact with DSO, InfoCube and InfoObject. Would that suffice?
Anonymous
Not applicable
Author

I appreciate, though in most (especially bigger) companies these accesses are strictly governed to stay with developers only.
Hence a more user oriented way would be to be able to read from user facing results which is Bex Web or Excel.
Hence BEx Web can be automatically triggered through calling a URL, I thought I could use HTML PARSE or similar and a trigger call to use it.
This way I could maybe use a bookmarked report, but tHe only thing missing is to enter filter parameters to the startup selection screen of a Bex query.
Maybe this describes better what I am facing.
Anonymous
Not applicable
Author

So you need something like a "REST" call with the right query paramters set and then parse the HTML response, correct?
In that case you can use components like tRestClient or maybe tFileFetch to do so
Thomas
Anonymous
Not applicable
Author

Sounds very much like it. 
If you happen to know Bex Web client - can you send me a short example how to configure these components?
I never used these two.
Thanks!
Anonymous
Not applicable
Author

An example path to one of our reports:
This brings up following screen:
Anonymous
Not applicable
Author

Forgot I cannot post links....
xxxx2.eu.xxxx.net:8070/irj/servlet/prt/portal/prtroot/pcd!3aportal_content!2fcom.sap.pct!2fplatform_add_ons!2fcom.sap.ip.bi!2fiViews!2fcom.sap.ip.bi.bex?QUERY=C9_D_C9_RMMM03_SC_FS809_LC9_M
Anonymous
Not applicable
Author

0683p000009MChh.pngas example for tRestClient
Anonymous
Not applicable
Author

0683p000009MCX4.pngor tFetchFile with GET verb and downloading to local file sytem.