how to connect to excel sheet and create a universe on top of that

[Former Member]

hi,

can any tell me how to connect to excel sheet and create a universe on top of that.what connection should i keep.

[Former Member]

Hi Vishal,

Here is how you can create a universe from an excel file:

Here are the steps to follow:

1. Launch Designer, select the Quick Design Wizard if not already open, and click "Begin".

2. Type in a universe name then click "New".

3. Select the Network layer "ODBC Drivers" and then click OK.

4. In the ODBC Drivers window, select the "Login" tab and then type in a name for this connection.

5. Select "Generic ODBC data source" from the drop-down list for database engine.

6. Click the "ODBC Admin" button to define data source name.

7. In the ODBC Data Source Administrator window, click Add.

8. Select "Microsoft Excel Drivers" and click Finish.

9. Enter a data source name.

10. Click "Workbook", select the file you want to access, and click OK.

11. Locate and select the data source name from the drop-down list.

12. Click "Test" to make sure that the server is responding.

You will be back at the Quick Design Wizard "Step 1 of 4". Click the "Next" button and follow through the rest of the steps in order to complete the universe.

-Shreyash

[amrsalem1983]

put this excel sheet somewhere on the server or some network drive accessed by the BO server.

then create ODBC connection from the

Control panel->administrative tools->Data Sources (ODBC).

select the excel sheet to create the system DSN

then go to the universe desinger, create new universe, in the connections click new connection.

select generic odbc driver

and i think you know the rest of the process.

good luck

[Former Member]

I'm afraid that I don't quite understand your question.

1. Are you trying to use an xls as a datasource for the universe? (you can try to create a new DSN using .xls as the driver - I never tried this, so I don't know how well it works)

2. Are you trying to use excel to pull in data from a datasource such as a webi report (which runs off of a universe)? Use LiveOffice for this.