tm1 process

Post Reply
airiarte
Posts: 2
Joined: Wed Aug 18, 2010 9:14 pm
OLAP Product: TM1
Version: 9.5
Excel Version: 2007

tm1 process

Post by airiarte »

I need help.

Environment
TM1 10.2.2
WINDOWS 2012 SERVER
SQL 2012 ENTERPRISE.

II am getting an error when editing TI process to bring data from SQL Database.
If I run the process, result successful. If I open the process to edit the sql query TM1 hangs. The tm1 log reports
TM1.SQLAPI IM002[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
This happens even if I reedit the SQL connection, user and password.
User avatar
macsir
MVP
Posts: 785
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1
Version: PAL 2.0.9
Excel Version: Office 365
Contact:

Re: tm1 process

Post by macsir »

You need to figure out the version of each software and ODBC. i.e. 32-bit or 64-bit
It might be using the wrong version of SQL driver, I guess.
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/
Post Reply