cancel
Showing results for 
Search instead for 
Did you mean: 

Universe created from a Ms Excel sheet

Former Member
0 Kudos

Gurus,

I created an unuiverse on a Ms Excel sheet and created a webi report .

But the webi report does not work. Error message is : DataBase error : MicrosoftODBC driver manager Data source name does not found and no default driver specified. (WIW 10901)

However , the DSN exists !!!!!

Are they some parameters to be configured ?

Thanks 4 your help

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

OK

Former Member
0 Kudos

When you create a WEBI report it takes the universe from BOE repository. The universe you created on Excel file. Excel File should exist in repository. It should DSN. It should be a windows enivornment.

Where as DESKI and WEBI rich client will use the universe from your local pc where the universe has been created it takes the local dsn. So you could create the reports smoothly on these kind of universe.

Do the changes accordingly and try you will get your result.

Former Member
0 Kudos

Hi satyanarayan,

How can i add my excel file in Repository?

Regards,

Rishit Kamdar

Former Member
0 Kudos

upload the excel file with ftp and create the dsn at repository. point the universe connection to this new dsn

Former Member
0 Kudos

Thanks for your reply. I already solve the problem.

Regards,

Rishit

Former Member
0 Kudos

Are all your servers on one machine?

If not so, please add the dsn to all the server machines and then check.

-Shreyash.

Former Member
0 Kudos

Hi Firmin,

Can you please tell me how you have conncet excel file with universe?

Thanks,

Rishit

Former Member
0 Kudos

Firmin Kouassi,

Could you please explain me how did you create uiniverse using excel sheets as source...???

Thnaks,

Ravichandra