Skip to Content
0
Former Member
Aug 05, 2016 at 08:40 AM

Update / Refresh Excel as source for WEBI report and web services

1473 Views

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:

  1. Schedule the original report
  2. Export it to Excel every night
  3. Create a new webi report using above Excel as source
  4. Export web services from the second report so it will be fast

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