Skip to Content
avatar image
Former Member

Universe using Excel File

Hello everybody,

I'm trying to create a universe out of an excel file. I've added the connection in System SDN, and placed the excel file in the server. However, every time I try to create a connection in Universe Design Tool, it keeps showing "The server is not responding (SBO0001)".

I've tried using Driver do Microsoft Excel (.xls), Microsoft Excel Driver (.xls) and Microsoft Excel-Treiber (.xls) when setting the new data source on server, and I've also tried using ODBC Driver from Microsoft -> Excel Spreadsheet and Microsoft -> MS Excel 2003 on Universe Design Tool but it was not successful.

However, when I tried to test the connection locally by setting up the System SDN in my local computer instead of in the server, the connection works. Can anyone point out where I did it wrong?

Thanks.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 08, 2013 at 08:32 AM

    Hi Ucci,

    Please check these tow KB to resolve the issue :

     

    https://service.sap.com/sap/support/notes/1299432

    https://service.sap.com/sap/support/notes/1453400

    I hope that thsi help.

    Best Regards

    Ines

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Ines BEN AMMAR

      Dear Ines,

      Thank you for your help. I finally added same connection in my local machine, and I did all the steps you instructed, and now I already have the universe I wanted.

      I think it's the problem with 64 bits machine because we have similar errors when we tried to use WebI for the first time weeks ago.

      Thanks.