Excel as External Data Provider

building reports webintelligence
1

Hi,

I created a Excel file in Exccel 2007 and trying to use it as External Source to create report in Web Intelligence Rich Client in XI 3.0, I am getting the error when I try to browse the file.

"Unable to create or update Excel Personal Data provider : Cannot Open the workbook (WIS 10872), But when i tried to do the same using Desk top Intelligence it works fine.

Any thoughts on this?

Thanks,
Baazi

Baazigar :india: (BOB member since 2004-06-10)

2

Because, personal data provider is not supported in Web-I.

Edit: Thanks Marek. Also I checked with the ā€˜What is New guideā€™. Personal data providers is supported. Sorry for my wrong information. It was true before this release.

Jansi :india: (BOB member since 2008-05-12)

3

Are you sure about this statement when it comes to WebI Rich Client in BO XI 3.0 :?:

Marek Chladny :slovakia: (BOB member since 2003-11-27)

4

You can use Excel as personal data provider, but not Excel 2007 (.xlsx)

jemstar :ireland: (BOB member since 2006-03-30)

5

What does this means? Canā€™t we save Excel 2007 as extension (.xls)?

aniketp :uk: (BOB member since 2007-10-05)

6

Of course you can save a Excel 2007 .xlsx file as an Excel 2003 .xls file.

jemstar :ireland: (BOB member since 2006-03-30)

7

That means Excel 2007 xlsx can be used as a data provider. This is what I wanted to confirm. :slight_smile:

aniketp :uk: (BOB member since 2007-10-05)

8

An Excel 2007 .xlsx file cannot be used as a data source, but a .xls file created by Excel 2007 can be used as a data source

jemstar :ireland: (BOB member since 2006-03-30)

9

I :yesnod: to Makā€™s suggestion, itā€™s the best. Also it depends if you want to compare some value or say you want a particular field from Excel, read the below post, may help you -

aniketp :uk: (BOB member since 2007-10-05)

10

Hi, guys. New user of BOXI Rich client here. I am running into this issue with using excel as a data provider. I build the query, create the report, refesh etc and everything is running fine. Then all of a sudden I get the message ā€œUnable to create or update Excel Personal Data provider : Cannot Open the workbook (WIS 10872)ā€

Am I missing something or is there a way to fix this. I have not made any changes to the excel file, it is not password protected, has not changed location etc.

Any suggestions are very welcome :?: Oh, it is Excel 2003.

Thanks all

Brandr3 :ireland: (BOB member since 2010-04-14)

11

I am running into the same issue and get the ā€œUnable to create or update the Excel personal data provider: an internal error occured. (WIS 10884)ā€ error. I canā€™t edit or delete the Excel data provider now. If anyone has found a way to edit or delete, please let us know. Thanks!

thamrick :us: (BOB member since 2004-05-18)

12

Hi,

I just ran across this problem. Iā€™m using Webi RC XI 3.1 SP3.

I managed to resolve the problem by removing a sheet that contained a pivot table of data on another sheet.

I was then able to use the .xls spreadsheet in Webi as a PDP. :smiley:

Cheers,
Chris

ChristianKey :uk: (BOB member since 2008-09-19)

13

That Simply doesnā€™t make sense at allā€¦BO and itā€™s weird behaviour :nonod:

nitin_gons :india: (BOB member since 2009-05-26)

14

Iā€™m having an issue where, when running the report in rich client, I get the Excel data provider information. Yet, when I publish the report to the repository and then run the report, I get the following error:

No data to retrieve in Query 2.

Does anyone know if thereā€™s something i need to set as a configuration on the server side?

TIA

Ray

xray1000 (BOB member since 2010-11-08)

15

Hi Ray,

Welcome to BOB!

It sounds like when you run your report from Webi Rich Client that your spreadsheet is available to your PC. But when you publish your report to the repository the spreadsheet is no longer available.

Is your repository on a server that is different to your local machine where you are running Webi RC from?

Can you navigate to the spreadsheet from the server where your repository is located?

Try referencing the spreadsheet using a full UNC path if not already doing so.

Chris

ChristianKey :uk: (BOB member since 2008-09-19)

16

Thanks for the response.

Iā€™ve tried using the fully qualified path to the data provider. The only thing left is to place the file on the database server where the repository is and set the path to the local drive.

Iā€™ll give that a shot and post back.

Thanks again :lol:

xray1000 (BOB member since 2010-11-08)

17

Hi,

The Doc seems to have set Refresh On Open to true. Putting the Source at a UNC Path may not work always. The file can be put at a pre-defined location on the server to get wid refresh work. For details which you wanted please see the Documentation or Please see post at http://forums.sdn.sap.com/thread.jspa?messageID=9582368#9582368

Regards
Sumitesh

SumiteshRS (BOB member since 2010-08-05)

18

Hi,

You need not put the file on the server exactly at the same place which you used to create it.

Regards
Sumitesh

SumiteshRS (BOB member since 2010-08-05)

19

I want to make sure I am hearing the right thing here. You say you CAN use Excel spreadsheet as a Data Source in WEBI?

I didnā€™t think you can and I have a reporting requirement coming up which this will fulfill.

Thanks.

toscajo (BOB member since 2002-09-04)

20

Hi Toscajo,

Yes you can use Excel in Webi Rich Client as a datasource in BOE XI 3.1.

Chris

ChristianKey :uk: (BOB member since 2008-09-19)