Well, I'll write some posts for people like me, VBA's nostalgics.
Remember, there was a great time for older versions of Business Objects, when you can get or create wonderful tools with Excel and VBA. These tools were open, and we could improve it easily, with a minimum of VBA's knowledge. But VBA didn't evolve with BI4. And I haven't found specific Excel tools for BI4, to describe an unx file for example.
But ... with RESTful API you can use any langage ... Java, Powershell, Python ... and why not Excel ? Excel can work on Big Data, why not RESTful API ?
I asked myself how we can use Excel with RESTful API, I made some tests/scripts and I'll share my feedback in this blog, following these posts :
:!: Notes :
Some advantages of RESTful Excel Tools :
I think Excel is not the easiest tool when you want manipulate a RESTful API, but like someone said, "yes you can" !
And Excel has the great advantage to be on most pc ...
With the older VBA SDK the BI4 Clients are needed. And sometimes the version of dll was in conflict with the downloaded excel script ... With RESTful API the BI4 Clients are not more needed. You just have to reference two libraries :
These dlls are out-of-the-box with Excel (tested with Office 2010 and +), it's so easy !
Some disadvantages of RESTful Excel Tools :
But with RESTful API you can't do everything like VBA. You can't get all informations on universe for example ...
And if you call the RESTful web service a lot of time, Excel will crash ...
I'll explain this later.
Next Step : let's start with logon/logoff !
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
8 | |
5 | |
5 | |
4 | |
4 | |
4 | |
4 | |
3 | |
3 | |
3 |