TM1 Forum

Dear TM1 exeports,

I am starting learning TM1,
I want to install TM1 on my local machine. I have a problem now:
My laptop OS is 64 windows 8
I have 64bit TM1 10.1
I have both 64 bit and 32 bit MS office2013

Firstly, I installed 64bit MS office, but the TM1 10.1 perspective does not work. I googled, it told me it does not support 64 bit MS office, so I uninstalled the 64bit MS office and then install 32 bit MS office.
I run the perspective , it worked.
everything was looking good so far.

but whne I run arctect to build a process use ODBC to connect the Excel files, the problems came out, I can not create a 64 bit ODBC for TM1, and TM1 only knows/uses 64 bit ODBC.
Anyone can give me solutions?

Thanks in advance

Ittimes

Export the Excel file to CSV and use that as your data source for TM1. If you absolutely HAVE to load it as an ODBC source you have to have the 64-bit ODBC driver for MS Office installed and you probably don't.

tomok wrote:Export the Excel file to CSV and use that as your data source for TM1. If you absolutely HAVE to load it as an ODBC source you have to have the 64-bit ODBC driver for MS Office installed and you probably don't.

Thanks Tomok, Yes, I tried to install '64-bit ODBC driver for MS Office' ,but there is a message said 'you have 32bit Ms office installed, you have to uninstall it first then you can install the 64 bit ODBC driver for Ms office '

I assume you are trying to use an ODBC connection for excel because it is part of a training manual you are using?
Someone I'm working with at the moment who is training up asked me the same thing this week and I told him that I have never come across anyone using the ODBC connection for excel through TI simply because you can connect straight to excel; however there is certainly merit in using the ODBC connection as part of your training. As such I created an SQL table and loaded the file into that so he could query it properly. I would recommend you do the same as then you get to do the training just as shown in your manual but you get the added benefit of starting to connect to a database with TI which is more like something you would actually do outside of a training context.

If you are doing this all on your PC and don't currently have access to an SQL server you can download an express version of SQL or the community version of MySQL is pretty good for such purposes as well.

I'm not quite sure if this Parameter is available in 10.1 or if it's introduced in 10.2 But try
in the tm1s.cfg file. This tells TM1 to also use 32bit-ODBC drivers

If this is for training, why not just install 32-bit TM1? It's unlikely you're going to need > 3GB.

declanr wrote:I assume you are trying to use an ODBC connection for excel because it is part of a training manual you are using?
Someone I'm working with at the moment who is training up asked me the same thing this week and I told him that I have never come across anyone using the ODBC connection for excel through TI simply because you can connect straight to excel; however there is certainly merit in using the ODBC connection as part of your training. As such I created an SQL table and loaded the file into that so he could query it properly. I would recommend you do the same as then you get to do the training just as shown in your manual but you get the added benefit of starting to connect to a database with TI which is more like something you would actually do outside of a training context.

If you are doing this all on your PC and don't currently have access to an SQL server you can download an express version of SQL or the community version of MySQL is pretty good for such purposes as well.

Thanks Declanr, you are totally correct, Yes, I want to use ODBC just because a traing course.

mattgoff wrote:If this is for training, why not just install 32-bit TM1? It's unlikely you're going to need > 3GB.

Sorry I don't have 32bit TM1 install package. Anyeone can share it?

Willi wrote:I'm not quite sure if this Parameter is available in 10.1 or if it's introduced in 10.2 But try

Code: Select all

EnableODBCproxy=T

in the tm1s.cfg file. This tells TM1 to also use 32bit-ODBC drivers

This parameter does not work

Sorry I don't have 32bit TM1 install package. Anyeone can share it?

http://www.tm1forum.com/viewtopic.php?f=3&t=5180 - read this pls and I think quickly forget about asking to share TM1 installs here
IBM is able to share it; this forum is not about sharing any kind of install of tm1

EnableODBCproxy=T

This works from 10.2.2 onwards
http://www-01.ibm.com/support/knowledge ... proxy.html

With 10.1, if you want to have the 64bit odbc but 32 bit excel, you should:
1. uninstall all excel components (including the excel odbc drivers)
2. Install 64 bit ODBC driver (but ONLY the drivers, NOT the Excel itself)
3. Install Excel 32bit, without the odbc drivers

The order is important, it worked for me on a 10.1.1 install with 2007 Excel, we have been using it for 1.5 yr now in a Prod environment without any issues. The reason why odbc is nice with excel is that we can use sql statements that helps a lot when it comes to filtering or sorting source data.


http://www.tm1forum.com/viewtopic.php?f=3&t=6448

mvaspal wrote:

Sorry I don't have 32bit TM1 install package. Anyeone can share it?

http://www.tm1forum.com/viewtopic.php?f=3&t=5180 - read this pls and I think quickly forget about asking to share TM1 installs here
IBM is able to share it; this forum is not about sharing any kind of install of tm1

EnableODBCproxy=T

This works from 10.2.2 onwards
http://www-01.ibm.com/support/knowledge ... proxy.html

With 10.1, if you want to have the 64bit odbc but 32 bit excel, you should:
1. uninstall all excel components (including the excel odbc drivers)
2. Install 64 bit ODBC driver (but ONLY the drivers, NOT the Excel itself)
3. Install Excel 32bit, without the odbc drivers

The order is important, it worked for me on a 10.1.1 install with 2007 Excel, we have been using it for 1.5 yr now in a Prod environment without any issues. The reason why odbc is nice with excel is that we can use sql statements that helps a lot when it comes to filtering or sorting source data.


http://www.tm1forum.com/viewtopic.php?f=3&t=6448

Thanks Mvaspal, I tried your way for Ms office2013, it did not work.

when I have the 64bit ODBC driver installed, it will not allow me to install the 32 bit Ms office

ittimes1 wrote: when I have the 64bit ODBC driver installed, it will not allow me to install the 32 bit Ms office

Can you provide more detail as to how it "will not let you"? Such as the exact error message?