TM1 Forum

I'm not so concerned about the JDE date, since it is a fixed length, have only included it in this thread as an example. There are three other variables used in these processes that are not fixed length, which required the SUBST / SCAN functions. Ran two quick tests this morning using the following ...

When I output the source data and the function results to a text file, this is what I'm seeing on the TM1 9.1 server: "107240.000000","107241.000000","113043.000000","Bill-To 107240","107240 107241","107818 107817" "107420.000000"...

I was wondering if this issue might be unicode related. What's interesting is that when the formula is open in the editor and you click the evaluate button, the function returns the correct results for all the formulas that use SUBST / SCAN. We only see the error when the process is actually executed.

We are upgrading to TM1 10.1.1 and have encountered some issues using various functions with TM1 10.1.1. We have several load process on our existing TM1 production server (TM1 9.1) that have been running for years without any issues. But when we copy the production database to our TM1 10.1.1 test s...

We are in the process of upgrading to TM1 10.1 and we are noticing the installation of the new TM1 10.1.1 client takes a lot of time to complete. We just ran an install of just the TM1 Perspectives component on a Windows 7 64-bit machine, which took approximately 33 minutes to complete: File Transfe...