Question Re: WID using XLS Possible? in Technology Q&A

WID using XLS Possible?

Former Member — Tue, 17 Aug 2010 16:43:01 GMT

Of course it is. Who knows how to do it correctly? I've uploaded my simple WID file to BOXI R3 and I have the XLS file as well... but I'm not sure how to force the source file on the WID report to point to the XLS file in the same folder. It is still pointing to the XLS on my local drive which will obvi not work.

Any kind of help is greatly appreciated.

Re: WID using XLS Possible?

former_member142702 — Tue, 17 Aug 2010 23:54:04 GMT

When you publish a webi report in the BOBJ server, which uses a local Excel file, then the data are stored in the report but the reference to the Excel file is not available anymore.

What you can try is to build a universe on top of the excel file (using eg. an ODBC connection). You have to setup the ODBC driver on the BOBJ server in order to get this to work.

Regards,

Stratos

Re: WID using XLS Possible?

hansen_chen — Wed, 18 Aug 2010 23:47:37 GMT

In XI3.1 SP3, the WID in Infoview can retriece data from local file. Make sure the file can be accessed from the WebI server.