Webi/Live office in Xcelsius

[system]

Hi

please check these links

120×120 10.4 KB

How to refresh all WebI and Xcelsius reports automatically (Fastly) We have around 1000 reports and we are refreshing all reports manually every month. We get Database files very month and have to refresh all reports on this database(ETL Load). Then we copy all refreshed reports with data to Production env. and then all end usres are using those all reports. User is happy for the development(reports) but the problem is once we receive database files we start refreshing all reports manually and…

120×120 10.4 KB

I happened to run across this today: (We use InfoSol for some of our scheduling needs.) Has anyone used it in this fashion (with Xcelsius) and can comment on it? thanks. dnewton (BOB member since 2004-01-30)

120×120 10.4 KB

I know some others have already come up with the “one line of code” that does this “refreshing of a document” using Live Office with Microsoft Office 2003 but as I discovered during a recent customer visit this platform is becoming fast obsolete and many people need another solution. Therefore I attach the following 2 spreadsheets in the attached ZIP archive file which are based on the Efashion universe which allow the user to refresh a Live Office report using a VBA macro. Instead of using th…

Thanks

---

osrootofos (BOB member since 2012-02-10)