Skip to Content
author's profile photo Former Member
Former Member

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

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 05, 2016 at 08:52 AM

    Hello Jay,

    You can make use of Event based scheduling have a look at below document.

    Automate scheduling using File event

    Regards

    Niraj

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 05, 2016 at 04:27 PM

    Hi Jay ,

    I think the approach you are following is mostly work when we have a universe in between the scheduled excel and the webi.

    schedule webi output with specified name to a share folder .

    create ODBC , use that ODBC to create universe .

    Create webi on newly created universe.

    This will mostly work , but its not need . I would say

    'use latest instance of the schedule document '

    or.

    'fine tune the database /original webi report to achieve the required performance '.

    Thank you.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.