Load data from Excel workbook

[Resser]

Hello,

I'm using the Performance Modeler to load data from an Excel workbook to a cube. The workbook contains multiple spreadsheets and is actually built like a relational database. Since I can only select one spreadsheet as a datasource I cannot map all dimensions in my cube. Is it possible to consider all spreadsheets in the process or do I have to create an ODBC source to use all required data at a time?

[BariAbdul]

Yes, You need to have Microsoft Excel Driver to create an ODBC connection to the Excel source and load the data.

More information about it could be found here :http://stackoverflow.com/questions/1584 ... c-database. Thanks

[Resser]

So when using Performance Modeler I connect to a remote TM1 server. Therefore I assume I have to set up the ODBC source on the server and not on the client. Is that right?

[BariAbdul]

You are correct.Since the TI executes on the TM1 server, the ODBC DSN needs to be set up there.Thanks