My organisation has some complex webi reports that we want to expose as web services for use with SAP Dashboards. Unfortunately these reports contain many variables, they are slow to load in WEBI (2-3 mins) and as a consequence retrieving web services, even for a pre-scheduled report can take between 1 and 60 seconds for a few rows of data. This is unacceptably slow.
It struck me that it would be quicker to:
There is some helpful information here (Microsoft Excel as data source for Web Intelligence) but I can't figure out how to refresh my report from a new (but identically named) Excel file each night. How do I do this? Where should I schedule the destination for my Excel file so that it can be picked up every night in the second webi report? Thanks
SAP BusinessObjects BI Platform 4.1 Support Pack 4 Patch 12
Version: 14.1.4.1772