Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Universe created from a Ms Excel sheet --

Hi Good Morning,

I created One webi report in BO .Now i want to create a universe from MS Excel File .Please tell me step by step Process .

Thanks In Advance

Praveen Kumar Yagnamurthy.

Former Member
Former Member replied

Please try the following steps to create a universe on excel file

1. Open the Excel spreadsheet

2. Select all the data values, make sure the remaining blank cells donu2019t get selected

3. Click on Insert>>Name>>Define to give a name to the table

4. Save the Excel

5. Go to Start>>Control Panel>>Administrative tools>Data Sources(ODBC)

6. Select System DSN>>Add>>Microsoft excel Driver(*.xls)

7. Give a new data source name and click on Select workbook and point the saved excel sheet and click on OK

8. Create a new connection in Universe designer by using the Generic ODBC connection

9. Create a new universe and insert the table which we have defined in the Excel sheet


1. Make sure the parameter <Parameter Name="Transactional Available">No</Parameter> is set to Yes under the Generic ODBC data source in below location

C:\Program Files\Business Objects\Business Objects Enterprise 11.5\win32_x86\dataAccess\connectionServer\odbc\odbc.sbo

2. If you would like to export the excel universe to CMC try these steps on your BO server machine

3. This workaround only works for windows server machine


Manoj Kumar

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question