TM1 Forum

Thanks Alan for the prompt reply, I had exactly the same thought a minute after posting. I went with ## Look for negative value entitlements with trailing sign IF(SUBST(LSL_Hours_Ent,LONG(LSL_Hours_Ent),1) @= '-'); LSL_Hours_Ent_Calc = '-'|SUBST(LSL_Hours_Ent,1,LONG(LSL_Hours_Ent)-1); LSL_Hours_Ent_...

We are just moving to a SAP payroll system, and it produces negative values with the sign at the end, ie 2.365- instead of -2.365.

Does anyone have any brilliant idead for loading this via TI? I currently get a warning telling me that it cannot the value to a real number.

Thanks

Last night I went to a presentation in Sydney about, amongst other things, a new text editor for TI that is about to be released by CubeWise, a Sydney company. This looks like the editor we (or at least I) have been waiting for! From what I remember, it: * works through the TM1 API * has a colour, l...

Thanks Paul, that worked. My problem was indeed not finished the joins before using a where

Thanks, it's Oracle.

I will give this a go.

First of all, a big thanks for this forum. I have been unable to get access to the Cognos one, and from what I read, I needn't bother. I have been trying to write extracts from our ledger (Ellipse / Mincom) via TI, and am having an SQL headache. I have been able to get other queries to work, but thi...