EXCEL AS A SOURCE FOR WEBI?

[system]

Guys,

Is it possible to use excel as a source for webi to create the reports? like DeskI?

Any Help!!!

---

balajibo (BOB member since 2009-04-24)

[system]

120×120 10.4 KB

Hi I am sure that there is no way to fetch data from Excel in WEBI , but still i thought I should ask once. I have a column in Excel sheet and I want that field in WEBI report. Also i have fields coming from different unvierse. The report is ready only one field (from excel sheet) is remaining, So could someone suggest the best way of implementing this problem. Thanks Aniket aniketp (BOB member since 2007-10-05)

Or

120×120 10.4 KB

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 (BOB member since 2004-06-10)

Rest it is not possible.

---

aniketp (BOB member since 2007-10-05)

[system]

Hi thanks

i saw that post, but still!!! i want to use excel file like we are using in DeskI

---

balajibo (BOB member since 2009-04-24)

[system]

How about some basic information, what version are you using?

PS don’t shout :)!

---

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

[system]

You need the Rich client in order to do this. You cannot do it in WebI alone.

---

Patti Medina (BOB member since 2009-09-28)

[system]

you can use EXCEL by using it as your universe source then you can use that for making a report in webi

Regards,

John Vincent

---

jvmauricio (BOB member since 2009-08-03)

[system]

Hi!

Yes! you can use Excell as your source on webi.

You can use the ODBC to create connection on your Excell File.

Thanks!
MeZ

---

mez19 (BOB member since 2009-08-10)

[system]

OK, let me clarify a few things…

3.1 - You can use Excel as a personal, localised source for Webi Rich Client.
If you wish to have this available, as refreshable, on Infoview you would go the universe route.

3.1 SP2 - You are supposed to be able to use Excel sheets, other personal Dps within webi, at least thats what it says in the whats new for 3.1 SP2 document.
However, I haven’t read anyone that has managed to acheive refreshable dps from within Infoview and I haven’t tried it, myself :? .

---

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

[system]

@mez19

Hi!

Yes! you can use Excell as your source on webi.

You can use the ODBC to create connection on your Excell File.

Thanks!
MeZ

Mez, are you talking about XI R2?

---

aniketp (BOB member since 2007-10-05)

[system]

Mak 1…

The “what’s new in SP2” document talks about PDP’s using WEBI in Infoview, but the two words “API exposition” mean that you have to use SDK code to make it possible. It’s not out of the box. I also read the document and assumed it was possible until I re-read it and saw API.
Our BO account manager has confirmed it’s an SDK job.

---

richmona (BOB member since 2003-04-15)

[system]

Rich,

Thanks for this…:). I had read others bitter experiences, but had not had a chance to test yet.

Typical lack of clarity in the BO documentation…

---

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