Issue refreshing a report with Excel as the dataprovider

building reports desktopintelligence
1

Hi All,

We are using BO XI3.1.

I am designing a report based on data from Excel sheet. i’e I am using Excel sheet as a dataprovider.

The report in Deski or webi client works fine. But when I am trying to refresh the report from Infoview BO is throwing an error.

It says "The document contains one or more local data sources that can not be refreshed " (Err msg from Webi)

Deski Err msg: “Setprompts failed - The following dataproviders have not been succesfully refreshed DMA0007”

BO is installed on Solaris 10. And the excel data provider is on my local machine.

Please let me know if any one has some idea?

Thanks,
Rashmi

MSR_BO (BOB member since 2009-05-01)

2

I would bet it’s a location issue - where do you have that Excel file located, how do you refer to it in your report? I’m betting it’s not visible to BO, which is why Desk is OK but InfoView has problems.

We do that here, but I tell my users they have to use UNC naming, and that the path needs to be open to my service account - example:

Hope that helps,
Brent

bdouglas :switzerland: (BOB member since 2002-08-29)

3

I know you can’t do this via a Webi report in 3.0, I discussed it here:-

https://bobj-board.org/t/119815/20

As for Deski, Brent, what version are you running?

Mak 1 :uk: (BOB member since 2005-01-06)

4

Hi Mak,

We’re a XI 3.0 shop here - I know we’ve gotten Deski reports set up like this; it’s a common way for us to link our EDW to data from another source dropped into a CSV file. I think we also did some Rich Client reports that way, but I’m drawing a blank on that now.

The client reports could do this all the way back to Webi 6x, but we tried to limit client reports in our Webi environment - too hard on the servers to run the busobj processes.

Hope that helps (and is accurate),
Brent

bdouglas :switzerland: (BOB member since 2002-08-29)

5

Cheers Brent!

Yep, know what you mean about the old busobj processes :slight_smile: and don’t get me started on com errors :roll_eyes:!

As I said before, I didn’t think Rich client docs, once published and thus becoming a Webi doc, could support a refreshable personal DP…

Mak 1 :uk: (BOB member since 2005-01-06)