Search found 2418 matches

by Wim Gielis
Mon Jul 13, 2020 9:19 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Expand function with numbers
Replies: 11
Views: 171

Re: Expand function with numbers

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...
by Wim Gielis
Mon Jul 13, 2020 3:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Expand function with numbers
Replies: 11
Views: 171

Re: Expand function with numbers

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...
by Wim Gielis
Sun Jul 12, 2020 5:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Expand function with numbers
Replies: 11
Views: 171

Re: Expand function with numbers

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...
by Wim Gielis
Sat Jul 11, 2020 10:18 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Expand function with numbers
Replies: 11
Views: 171

Re: Expand function with numbers

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....
by Wim Gielis
Sat Jul 11, 2020 9:37 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Expand function with numbers
Replies: 11
Views: 171

Re: Expand function with numbers

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 🙂
by Wim Gielis
Fri Jul 10, 2020 8:37 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Expand function with numbers
Replies: 11
Views: 171

Re: Expand function with numbers

Thanks ascheevel. If we can only use 'masks' in the last LogOutput line, that would be great :-) Tricky problem I'm afraid.
by Wim Gielis
Fri Jul 10, 2020 6:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Expand function with numbers
Replies: 11
Views: 171

Expand function with numbers

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....
by Wim Gielis
Thu Jul 09, 2020 11:49 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rule Efficiency
Replies: 4
Views: 114

Re: Rule Efficiency

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.
by Wim Gielis
Thu Jul 09, 2020 11:14 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW information for PAX
Replies: 10
Views: 222

Re: PAW information for PAX

With Covid-19, the holidays are different/much closer to home anyway :lol:
by Wim Gielis
Thu Jul 09, 2020 11:03 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rule Efficiency
Replies: 4
Views: 114

Re: Rule Efficiency

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.
by Wim Gielis
Mon Jul 06, 2020 9:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: STR(Num, len, dec) with only one argument
Replies: 11
Views: 619

Re: STR(Num, len, dec) with only one argument

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
by Wim Gielis
Mon Jul 06, 2020 10:21 am
Forum: Enhancements
Topic: DBS should fail, hard!
Replies: 6
Views: 196

Re: DBS should fail, hard!

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 😉
by Wim Gielis
Sun Jul 05, 2020 9:58 am
Forum: Enhancements
Topic: DBS should fail, hard!
Replies: 6
Views: 196

Re: DBS should fail, hard!

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.
by Wim Gielis
Sun Jul 05, 2020 9:56 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1py Use Case
Replies: 3
Views: 161

Re: TM1py Use Case

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...
by Wim Gielis
Thu Jul 02, 2020 11:01 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Automating TM1 in VBA
Replies: 20
Views: 2915

Re: Automating TM1 in VBA

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 !
by Wim Gielis
Tue Jun 30, 2020 7:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Experience with PAW and its future prospects
Replies: 12
Views: 599

Re: Experience with PAW and its future prospects

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...
by Wim Gielis
Tue Jun 30, 2020 3:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Automating TM1 in VBA
Replies: 20
Views: 2915

Re: Automating TM1 in VBA

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...
by Wim Gielis
Tue Jun 30, 2020 10:52 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Automating TM1 in VBA
Replies: 20
Views: 2915

Re: Automating TM1 in VBA

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.
by Wim Gielis
Mon Jun 29, 2020 8:10 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: LogOutput fails where AsciiOutput runs fine
Replies: 3
Views: 312

Re: LogOutput fails where AsciiOutput runs fine

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...