Skip to Content
author's profile photo Former Member
Former Member

create universe from excel sheet

Hello everybody,

I am trying to create a universe from an Excel Sheet.

This should be possible because when selecting "Microsoft" as a source, there is the option "Excel Spreadsheet" and under that ODBC-driver. Unfortunately I cannot find any field referencing to a source excel file name or something.

Has anyone done an Universe from an Excel sheet?

My goal would be to create an Xcelsius Dashboard with live data coming out of an Excel file.

Thanks

Victor

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Sep 29, 2009 at 12:44 PM

    Hi,

    For creating an universe from the excel sheet first of all you need to create a system DSN at the server end and have to place your excel at the server.

    Go to ODBC Data source Administrator -> System DSN -> Add -> Microsoft Excel Driver.

    then specify the data source name and browse the excel sheet on clicking Workbook (not remember exactly).

    Now go to universe designer in the available connections you should be able to see the created DSN name. now you can import tables and go-ahead with the universe creation.

    Regards,

    Rohit

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 05, 2009 at 12:11 PM

    Hi,

    To use Excel as a data source for universe then you have to create a Required DSN connection.

    For that go to Control Panel -> Performance and management -> Administrative tools -> ODBC Data source Administrator -> System DSN -> Add -> Microsoft Excel Driver(.xls) then specify the data source name and browse the excel sheet on clicking Workbook

    The new DSN connection will be reflected in universe connections so in universe designer under available connections you should be able to see the created DSN name. Select that DSN connection to required universe and import all data exists in it.

    Cheers,

    Suresh Aluri.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 05, 2009 at 11:53 PM

    Try the following steps to create an Excel universe

    1. Open the Excel spreadsheet

    2. Select all the data values, make sure the remaining blank cells don't get selected

    3. Click on Insert>>Name>>Define 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

    Note: Make sure the parameter <Parameter Name="Transactional Available">No</Parameter> is set to Yes under the Generic ODBC Data Source in below location

    ...\Business Objects\BusinessObjects Enterprise 11.5\win32_x86\dataAccess\connectionServer\odbc\odbc.sbo

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hello BOCP-BOE

      thank you for you reply. I will follow what you have mentioned about creating a DSN and storing the excel file on the computer on which BO Enterprise is installed.

      I am a newbie in this so may ask some funny question but i need to ask to make me clarify. So will a client have a computer on which they install the BO enterprise and then all the consultants/employees will get only the client version installed on their laptop. Am i right till now? and i need to find that machine on which the BO Enterprise is installed, save the excel file and create a DSN on that machine.

  • author's profile photo Former Member
    Former Member
    Posted on Oct 08, 2010 at 01:03 PM

    Hey here,

    To accomplish it, we have to do some other stuff.

    Tools needed: MS Excel, Designer, LiveOffice & Xcelsius.

    -- As stated in previous post and you know, develop WebI reports on top of Excel.

    Install LiveOffice and check-- View On Demand option and Save it. (In LO Object/ Application Properties)

    Install Xcelsius-- Now you can LiveOffice add-on in below spread sheet.

    Import the data what you want see and use it for Dashboard.

    Thank You!!

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.