Previous Post: ABAP Freak Show: February 4, 2009 Next Post: ABAP Freak Show March 4th Part 1
ABAP Freak Show: February 18, 2009
by Rich Heilman on February 18, 2009 at 11:19 am
In this episode of the ABAP Freak Show we will take a look at how to retrieve data from a NetWeaver ABAP system via web services, and consume that data inside of SAP Business Objects Xcelsius. We will start by creating the web service provider in NetWeaver, and finish up by creating the web service connection and building our model in Xcelsius. For this demonstration we will be working with a NetWeaver 7.01 system and Xcelisus 2008 SP1.
Good example Rich. Liked it a lot.
Cheers
Graham Robbo
Excellent show, Rich. I think you should throw this link up on all the many repeated SDN forums about how to get Flex working with an ABAP web service. I have added it to the SDN wiki page that I created for consuming ABAP web services from Flex.
Great show; thanks for filling in for Thomas while he was off partying in Cancun.
Cheers,
ewH
I actually tried something similiar a while back using the “QUERY_VIEW_DATA” Web service from SAP BI. This way I could pull in BI data without having to use the Query as a web service. Plus it’s always nice to use the ABAP stack as a giant caching engine for Dashboard information.
Really liked your end-to-end example. Very detailed and easy to follow.
I also think it shows the selling point of web services and Xcelsius. If you asked one of the product people from BOBJ, they would have told you to use a Crystal Report to pull the R/3 data and then create a Live Office connection to pull that into Xcelsius. No one but a true ubergeek would use the Netweaver web services to link directly to Xcelsius.
Keep um coming…
Is there a download associated with this demonstration? Where do I get the function z_get_sales_data_by_country?
Marv
Hi Marv. There is no associated download, and you just made me realize that I had just blown away the actual object from my system when I did a DB restore. So I can not provide it now anyway. It really was a very simple FM, actually it had a basic exporting parameter which used a table type which used a simple structure. Then I simply filled the table directly using dummy data in the FM code. So you could create your own very quickly. It does not have to be the same as my example.
Cheers,
Rich Heilman
Hello, great show. We did the everything described in the video and in other documentations, but we still get an error message 2170. Are there some other sepcial settings we have to do?
Thomas
Hello,
Good show and very userfull one …Thanx for taking out some time from your busy schedule ………….Thanx again Heilman