TM1 Forum

Well, in your code (where I corrected some typos): n = 2; s = '%n1%'; n1 = NUMBR(EXPAND('%n%')) - 1; LogOutput('INFO', EXPAND(s)); # will output 1 n = 3; LogOutput('INFO', EXPAND(s)); # will still output 1 because n1 is not reevaluated by calling EXPAND on s you introduce the variable n1. Why not le...

Hi ascheevel, I guess you have a different interpretation of my case. Your n1 definition should be fixed. It's only that it should take different values for n, each time you call it through Expand. I agree that if the definition of n1 changes, only the last definition can and should be used. In fact...

Lotsaram is right, the problem is in the 3 decimals when Expand is applied to a numeric value. The challenge is to enter '...' and %...% around the variable n in line 2. But if we do that, the MOD function will complain. n = 0; s = NumberToString( Mod( n, 1 ) * 10^6 ); n = Now; LogOutput( 'INFO', Ex...

I don't think I can get it working the way I would like to see it in practice :) This code: nStart = Now; s = NumberToString( Mod( nStart, 1 ) * 10^6 ); LogOutput( 'INFO', Expand( '%s%' )); Sleep( 5000 ); nStart = Now; LogOutput( 'INFO', Expand( '%s%' )); returns: 21776 [a] INFO 2020-07-11 12:15:51....

Interesting, I will play around to see if I can get it working with as minimal code in the LogOutput as necessary. If that means more code (once) in the Prolog tab I’m fine

Thanks ascheevel. If we can only use 'masks' in the last LogOutput line, that would be great Tricky problem I'm afraid.

Hi all, I am trying to log TI process run times in such a way, that I only need to specify some code at the top of the Prolog tab, followed by very minimal code further on in the process. If we can get this working, generic processes like Bedrock will be able to benefit too. The cases is as follows....

Feed the underling N level cells ( 'Forecast', 'Annual Revenue' ) based on the driver values.
They will feed into the future 1/2 periods, or stay within the same period.
Or, use a different value to feed from, if you know that makes sense business-wise.

With Covid-19, the holidays are different/much closer to home anyway

Performance-wise, go for the second option. Though there is N: and N: but you will have noticed that I guess, and also a parenthesis too much.

lotsaram wrote: ↑

Mon Jul 06, 2020 3:47 pm

I'm sure you mean double ctrl+c

I thought more along the lines of Ctrl-c c c

Alan Kirk wrote: ↑

Mon Jul 06, 2020 8:59 am

14 and counting. When does our bet money arrive in our accounts?

When IBM have implemented it

Steve Rowe wrote: ↑

Fri Jul 03, 2020 1:39 pm

I bet I don't get 10 likes!

Currently, you have 8 so 2 remaining.

Indeed, you even wrote this in a different topic, not so long ago: Thank you Everyone for your insights on this. I have been exploring TM1py samples and this has really given a better picture of python and TM1 integration and its capabilities. Can you guys please suggest some use cases on TM1py whic...

Thank you Paul, I will go through the material although I think I can tick many boxes here.
The need is not very urgent anymore so it can take a while for me to pick it up again but thanks a lot !

Good catch, thanks.

Indeed, for experienced TM1 developers, the efficiency goes down when developing in PAW. To name just 1 thing, if you press the first letter of a cube name you would jump to the first cube whose name matches the letter. That is what happens in Architect. Don't try this in Workspace, you need to scro...

Thanks Wim. Just to confirm my understanding, you're saying there is no known reliable approach to full report automation from TM1? :cry: I wouldn’t know if it is definitively a no-go but AFAIK you cannot get it working reliably and consistently if it is unwatched and without user “context”. I only...

Hi Oli,

I moved away from this approach if the reports should be generated without manual intervention.
Only when a user can generate the report, I still allow it. If we cannot be sure that it works reliably, it's better to not use it.

Hi Wim, Cannot test for you but you may need to escape the backslashes e.g. \\\\customer.local\\... Or switch them to forward slashes e.g. //customer.local/... Many thanks, both methods work. I am pretty sure I tried the / character and it seemed to not work during the tests, but now it does. I pro...