Excel as personol data provider

building reports desktopintelligence
1

Hi,

I would like to know whether while using excel as a data provider is there any option of taking multiple sheets of excel as data provider in BO 6.5.
As at present i am able to take only one sheet of excel as source data.
I would like to create more data providers with other sheets in same exel.

Regards,
Anoop

anoopwins (BOB member since 2009-03-18)

2

If you select excel as a personal dataprovider you can select the name of the sheet in the dropdown Sheet Name (under the heading Worksheet/Workbook File).

RJvanL (BOB member since 2007-03-13)

3

Hi

But i would be able to select one sheet and it would be my data provider.

But is there any way to select multiple sheets and thus to create multiple data providers at a stretch.

Regards,
Anoop

anoopwins (BOB member since 2009-03-18)

4

I don’t think we have such an option.

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

5

Hi anoopwins,

It is possible. But quite long process

create your each sheet as table.

steps 1: open excel worksheet.select complete data in it.Goto insert menu.
and select Name–> in that Define option
step 2 : Define Name form will appear.Put name Sheet1 or whatever you want.This will become one table in excel.Repeat steps for all sheet

Step 3: Goto ODBC & create XLS Datasource of sheet.

Step 4: Goto Business Objects Creat new report.Select Access data in different way.Then select Free Hand SQL option.

Step 5: Now you have to create connection with the datasource you have created in ODBC.

Step 6: put query : Select * from Sheet1

Please note that Sheet1 is Table name which you have define initially.

Like wise you can create multiple dataproviders using single XLS & then link those dataprovider.

Hope this will help you.[/b]

prashil123 :india: (BOB member since 2006-08-25)