Linking Excel file to a report and publish it.

Hi,

We are running BO v6.1b and we have a situation where we want to bring in data from an Universe and also an Excel spreadsheet in a report. I developed the report and it seems to work just fine in the Full Client, in my PC. When I publish the report to corporate repository, I get the following error message when I do a “refresh” in Infoview.

Automation exception BusinessObjects server process raised an automation exception. (Error: BOMGR 0060) IDispatch error #109 The Microsoft Jet database engine could not find the object ‘IC Data Base Query1$’. Make sure the object exists and that you spell its name and the path name correctly. (3011): [] The following data providers have not been successfully refreshed: Region Code Spreadsheet. (DMA0007): [] ()
(returned by function Refreshing Document) )

The ‘IC Data Base Query1$’ specified in the error message is the worksheet name in the Excel file and it is correct.

My question is: a) Is it possible at all to refresh this report in Infoview, because I assume the excel file has to reside in the BO server that is executing the report.

b) How does this work when the Excel file changes (in contents).

Any input on this kind of application is welcome.

Thanks!

Gana.


gana (BOB member since 2004-04-14)

Make sure the Excel file resides in the BO server with the same path like your PC. Meaning, If you have it under C:\BODOC\EXCELFILE , then the same path should exist in the BO server.

When the Content of the Excel file changes, you need to schedule/ refresh the report.

Hope this helps. :slight_smile:


Jony (BOB member since 2004-07-09)

Do I have to ‘manually’ put the file in each BO server? Also, when the file changes, do I have to ‘manually’ update the file in each server?

Is there any way to get rid of the path in the file location specification. For example, I would like to have the excel file reside in the same place the report file resides. In my PC it is say, c:\bo reports\x.xls. In the server, the report file might exist in a different file location. How do I tackle this?

Thanks for your time/effort.

Gana.


gana (BOB member since 2004-04-14)

Gana,

I have updated the files manualy on the server. If you have a lot of files to upload, you can automate the process by some batch scripts.

I don’t think of any other way to get rid the path. May be someone else can shed some light on this for you.

:nonod:


Jony (BOB member since 2004-07-09)

You can put this Excel file in a network folder and access it from that folder (through network path) while creating the report.

It shouls solve the problem.

HTH


shamit (BOB member since 2004-07-01)

When you publish a report with an excel file in it and want it to be refreshed with the report you must use a network path to the location of the report…

Let’s say you have the excel file on “serverA” and you publish the report to the repository that points to the excel file…

When you include the file in the report you must have the path defined this way:

Using the path like this, you must ensure that the file is accessable by the user that is owning the WebI server processes on the server, or at least all users…

Hope this helps… :wink:


n5xjb :us: (BOB member since 2003-09-15)