TM1 Forum

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?

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

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?

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