After sharing a basic method of automating the updating and distribution of your Analysis for Office files with Excel, this blog covers some of my learnings since my initial posts.
Post 1 : Automated updating of BW data in Excel files (BEX & AO) v...
If you have wanted to auto-update your BW files using a dynamic selection of variables and filters, then this blog may be useful to you.
What I’ll cover is how I’ve been able to do this with Excel VBA and Analysis for Office (AO).
My previous posts...
In my previous blog we used VBscript and VBA macros to update BW workbooks in BEX and Analysis for Office.
Its a simple and low cost way to auto-update your BW workbooks.
This blog will expand on that idea and include a more elegant way to do all t...
For a little while now I've been looking for hands-off ways to auto-update Excel files with data from our BW system, without having to use Broadcasting or any other additional servers.
After reading through numerous posts and forums from a lot of di...
Only a couple of options on that one, as Excel only saves a single PDF per file by default.
Build all off your results onto separate pages/sheets and save that all at once.
Build the three files separately as you do now, keeping track of the fil...
No I ended up running on a non-SSO account that was dedicated to the automated reporting (normal users are still using SSO), so never go round to fully looking for a solution.
Looking through the forums this post may help : https://answers.sap.com/q...
A couple of possibilities on this one. What are your specific trust settings, are macros set to be enabled by default? The second item that plays up sometimes is if you aren't forcing excel to be visible in your VBA. If its not visible on screen, the...
Its likely that issue is related to your BW systems authentication setup, potentially only allowing LDAP and not other direct connection options. Potentially try it against another account that isn't set up to use LDAP and see how that goes.
