Hello everyone,
I would like to export data from TM1 into SQL Server.
UPD: ODBC connection works well, but I still get error:
TM1.SQLAPI S0022 Invalid column name 'Department Store'
ODBCOutPut('IBMCOGNOSSQL_64b', Expand ('insert into dbo.TM1_sqlserver_output
(Channels,
Versions,
Months,
Products,
Price_Cost_Measures,
Wert)
Values
("%Channels%",
"%Versions%",
"%Months%",
"%Products%",
"%Price_Cost_Measures%",
"%Wert%")'));
"truncate table" and "insert into" together give an error, so I commented "truncate table" out
"invalid column name" error is solved as follows:
https://support.microsoft.com/en-us/kb/222664
If you are using a DSN connection to SQL Server you can also set Quoted Identifiers off by deselecting the option 'Use ANSI Quoted Identifiers' in the ODBC Administrator when you are creating or configuring the DSN to SQL Server.