Skip to Content

Creating a Webi Report with excel as automated process

Hi All,

Need your inputs here. I am using SAP BO 4.1 reporting tool. My requirement is to create a Webi report with Excel as source.

The challenging part here is that the whole process should be automated. I have to place an excel file in some shared location and the webi report should pick up that excel file automatically.User can only update the data in the excel and the headers and all will remain same.So when user refreshes the webi report the report should populate automatically the updated data.

Can any one please suggest me how to achieve this.

Thanks in advance.

Thanks

Faizan

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Nov 03, 2015 at 06:49 PM

    We currently do this with Webi now that you can point to an Excel file that lives on BI Platform.

    We have the owner of the Excel file upload to the BI Platform.  The Webi is setup to look at this Excel file on the platform. 

    As you noted, as long as the format stays the same, all you have to do is refresh the Webi to pull in the updated Excel data.

    This was new for us as we were on 4.0SP4  and now 4.1SP4.  In the old version Excel had to be local to the PC Webi Client tool to refresh.

    james

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 03, 2015 at 03:41 PM
    Add comment
    10|10000 characters needed characters exceeded