Skip to Content

Making a Universe on top of an excel file

Jun 14, 2017 at 04:45 AM


avatar image
Former Member

In IDT, I can see that it is possible to make a universe on top of excel file. In order to make that universe, I need to make a relational connection first. The relational connection requires an odbc connection at OS level. My excel file is located on the server side and I want to make a universe on top of that server's file ( The excel file located on server). I am connecting to my server through IDT.
I am confused about the odbc connection on the client side. Should I have to select a workbook on the client side, is it mandatory? How can I make that odbc connection point directly to the server's excel file.

Kindly help.

10 |10000 characters needed characters left characters exceeded


When you are creating a relational connection, select Location type and Publish to the repository.

While creating Data foundation layer select the Single or Multi source connection and connect to the published environment.

Yes, try creating a ODBC 32 bit.



* Please Login or Register to Answer, Follow or Comment.

0 Answers