• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VBA & Business Objects

P

Pierre

Member
Hello,

I am using Business Objects (Webi) and I would like to automatize the update of a specific request and get the data from this request directly in Excel.

Does someone has any experience with VBA & BO? Any piece of advice would be welcome :)
 
I looked a bit on the web but didn't think to check on SAP website :p

However those links only refer to the desktop version (Deski) of BO while I have a web version ("Webi", I acces it via a browser)

I found a remark here:
https://archive.sap.com/discussions/thread/3187186

It is said
"DeskI is a Windows app; an object model exists allowing VBA to do the work.

WebI is a web app that can be accessed via either a JSP or ASP object model. "

Does someone know what a JSP or ASP object model is?
 
Just use REST API to send request via xmlhttp etc.

Have a read of links.
https://help.sap.com/viewer/58f583a7643e48cf944cf554eb961f5b/4.2/en-US
https://github.com/VBA-tools/VBA-Web

But if you are not comfortable with coding... it's far easier to connect to SAP BO Universes via PowerQuery (will need Excel 2016 or 2013 with specific SKU etc).

Or just PowerBI to connect to SAP BO Universes.

See link for some details.
https://powerbi.microsoft.com/en-us...p-businessobjects-bi-now-generally-available/
https://thinkingbi.wordpress.com/20...businessobjects-universes-how-to-get-started/
 
Thanks for the link. What's the difference between Power Query and Power BI? Are those free tools or you have to pay for it?
 
PowerQuery/Get & Transform is Excel Add-in, and from Excel 2016, it comes packaged out of the box. It's very powerful tool for data gathering and transformation.

PowerBI is stand-alone tool that has PowerQuery as part of it's component. There is cloud subscription, but Desktop is free.

Do a google search and you'll find plenty of info.
 
power query and power bi are both free. Power Query is strictly query plus some pretty functional transformation functions. Power BI contains the same functionality as powerquery but also adds nifty dashboardish type display.
 
You must log in or register to reply here.
Back
Top