Skip to Content
0

WEBI: How to Refresh a WebI Report based on an Excel Sheet in a network share

Mar 17, 2017 at 02:16 PM

75

avatar image

Hi,

I would like to create a report on SAP BO WebI based on an excel file which is located on a network share. As long as I refresh it in the WEBI Richt Client, it works perfectly. But I must be able to refresh it on the BI Launchpad Platform.

Any idea how to do it?

Best regards,¨

Roman

10 |10000 characters needed characters left characters exceeded

Hi,

You can try as Amit Kumar suggested and another option is:

1. Save the excel to the BI Launchpad

2. Remap the WebI data source to the Excel saved in Bi Launchpad.

3. Refresh the report.

Thanks,

Jothi

0
* Please Login or Register to Answer, Follow or Comment.

2 Answers

AMIT KUMAR
Mar 17, 2017 at 02:53 PM
0

For this you need to check if user which is used in SIA for to run services has the access from BO server to Network drive?

Check what is the user name in SIA services and then from BO server try to access the network location.Report will work once you will get the access from BO server to Network location.

Share
10 |10000 characters needed characters left characters exceeded
Abhilasha Patil Mar 20, 2017 at 08:50 AM
0

Hi Roman,

When the Excel file is based on a shared/network location make sure that you are providing a UNC path.

Eg: \\host-name\share-name\file_path

And obviously check what Amit has suggested.

Regarding saving the Excel file on BI launchpad, this is the recommended way as the Excel is managed. And when making any changes to it you would have to replace the existing file. Check the below link for more info on this :

https://blogs.sap.com/2013/11/25/new-in-sap-bi-41-sp02-microsoft-excel-as-data-source-for-web-intelligence/

Regards,
Abhilasha Patil

Share
10 |10000 characters needed characters left characters exceeded