Search found 5 matches

by NewtoTm1
Tue Jan 17, 2017 11:31 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Update SQL Statement inside TI Process
Replies: 2
Views: 2810

Update SQL Statement inside TI Process

Hi Everyone, I am trying to write a sql update statement in a TI process but I keep getting an error 'SET key word missing' and execution is aborted. I have pasted out the part where I am using the update statement. It will be great if anyone could help me out with this. ----------------------------...
by NewtoTm1
Tue Jan 17, 2017 11:28 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Update SQL Statement inside TI Process
Replies: 0
Views: 1743

Update SQL Statement inside TI Process

Hi Everyone, I am trying to write a sql update statement in a TI process but I keep getting an error 'SET key word missing' and execution is aborted. I have pasted out the part where I am using the update statement. It will be great if anyone could help me out with this. ----------------------------...
by NewtoTm1
Tue Jan 17, 2017 11:26 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to write a SQL Update statement in a TI process
Replies: 0
Views: 1529

How to write a SQL Update statement in a TI process

Hi Everyone, I am trying to write a sql update statement in a TI process but I keep getting an error 'SET key word missing' and execution is aborted. I have pasted out the part where I am using the update statement. It will be great if anyone could help me out with this. ----------------------------...
by NewtoTm1
Mon Dec 12, 2016 10:11 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Exportcube from Tm1 to Oracle Table
Replies: 3
Views: 2396

Re: Exportcube from Tm1 to Oracle Table

Thanks much David for your response. I Made it work :).
by NewtoTm1
Fri Dec 09, 2016 10:55 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Exportcube from Tm1 to Oracle Table
Replies: 3
Views: 2396

Exportcube from Tm1 to Oracle Table

Hi All, I am totally new to Tm1 so I am here to get your help. I am using the below code to export the cube from Tm1 to Oracle. Everything is working fine but I am getting an error 'Quoted string not properly terminated' I found out the reason as well on why I am getting that error and that's becaus...