Search found 2 matches
- Wed Jan 13, 2021 4:35 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: SQL query works in SQL server but not in TM1
- Replies: 3
- Views: 6995
Re: SQL query works in SQL server but not in TM1
Thank you for your help. You are right I am using Management Studio. You are also probably right that it is probably an authentication issue - unfortunately there is limited knowledge about TM1 within our company. I fear that copying the entire code may be in breach of my company's security protocol...
- Wed Jan 13, 2021 2:51 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: SQL query works in SQL server but not in TM1
- Replies: 3
- Views: 6995
SQL query works in SQL server but not in TM1
Hi all, I have an SQL query that works in sqlserver but which gives my the following error in TM1. SQL Statement failed It produces the above error as soon as I open the process. Note that I am very new to TM1. Broadly the query is Select A.VAR1, B.VAR2, C.VAR3, [b][i][u]D.VAR4 [/u][/i][/b] from DB1...