A couple of favourites from older versions:
On cancelling a text output operation:
'Stop Now?'
On logging off an instance through the Explorer:
'Disconnect self?'
Search found 109 matches
- Wed Dec 11, 2019 1:56 pm
- Forum: Useful code, tips and tricks
- Topic: Cryptic TM1 Messages Decoded
- Replies: 71
- Views: 369805
- Tue Nov 19, 2019 3:32 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: DBRW vs DBR in PAx
- Replies: 2
- Views: 2884
DBRW vs DBR in PAx
Hi all, In the documentation for Planning Analytics for Excel, IBM states: " the DBR function is equivalent to the DBRW function". It goes on to say that both are optimised for network traffic. As regards the VIEW function: "VIEW is primarily used for compatibility with TM1® TM1 Persp...
- Wed Jul 25, 2018 9:59 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Having a rubbish TI editor is a good thing.
- Replies: 10
- Views: 7579
Re: Having a rubbish TI editor is a good thing.
A very interesting discussion. Here's my input: - A simple editor can be a good thing because once you learn syntax etc. thoroughly, you can code quickly; arguably more so than with a fancy editor. Intellisense is great, but... - The whole point of Bedrock I believe is to leverage modular programmin...
- Mon Jul 16, 2018 1:12 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Conditional feeder - how to force reevaluation
- Replies: 16
- Views: 12468
Re: Conditional feeder - how to force reevaluation
Regarding the parameter 'ForceReevaluationofFeedersForFedCellsOnDataChange', besides it being an extraordinary mouthful, I believe there may be a misconception about how it is supposed to work. The clue is in the '...ForFedCells...' bit. The parameter only forces re-evaluation of *ongoing* feeders f...
- Tue Jul 10, 2018 3:35 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX in ActiveForm with "INSTR" does not work
- Replies: 11
- Views: 13452
Re: MDX in ActiveForm with "INSTR" does not work
...and you must include both the first and the fourth '1' parameters to get Instr to work in Perspectives too. e.g.
{FILTER([Employee].MEMBERS,Instr(1,[Employee].[EmployeeID_Name],"Jones",1)<>0)}
That is at least true of Plan An 2.0
{FILTER([Employee].MEMBERS,Instr(1,[Employee].[EmployeeID_Name],"Jones",1)<>0)}
That is at least true of Plan An 2.0
- Tue Sep 12, 2017 1:27 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Threads on TM1RunTI
- Replies: 2
- Views: 2702
Re: Threads on TM1RunTI
Thank you David for these helpful hints.
Ian
Ian
- Tue Sep 12, 2017 11:59 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Threads on TM1RunTI
- Replies: 2
- Views: 2702
Threads on TM1RunTI
Good day/evening all, I have a batch of TM1RunTI.exe commands in a text file, running in parallel. Could anyone kindly tell me please, whether in a batch like this, TM1 looks for multiple cores and runs one thread on each, queueing processes till a core becomes free? And does it make any difference ...
- Wed Nov 11, 2015 1:21 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: HTML vs Windows clients
- Replies: 5
- Views: 4265
Re: HTML vs Windows clients
Yes!many of us got into this game because we like learning cool new technologies anyway.
Thank you Alan for your thoughts. I feel loved and re-invigorated by all this encouragement and will not now REST until I'm 'API.
- Tue Nov 10, 2015 2:33 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Prism?
- Replies: 21
- Views: 16530
Re: Prism?
We joked that a quick way to smoke out spurious TM1 'experts' at a job interview would be to ask them to demonstrate a keyboard copy-paste in the TI Editor.
- Tue Nov 10, 2015 12:10 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: HTML vs Windows clients
- Replies: 5
- Views: 4265
Re: HTML vs Windows clients
learning new tricks will also be required for professionals who want to stay relevant Indeed qml, and I'm up for that. It really helps to hear your thoughts and experience. Coasting sounds attractive, but I suppose we should not 'go gently' and all that. Thanks. :) Don't get your pipe and slippers ...
- Mon Nov 09, 2015 10:40 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: HTML vs Windows clients
- Replies: 5
- Views: 4265
HTML vs Windows clients
Apologies if this topic has beeen discussed here. I am wondering whether my TM1 skills will still be marketable in 5 years' time, given IBM's HTML/Java-based strategy for TM1 clients, without entirely embracing the new way of doing things and learning in depth about a much larger stack of TM1 client...
- Wed Nov 04, 2015 2:42 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Monthly Poll 201510_201511 - Do you plan to use CAFE as a replacement or supplement for Client and Why?
- Replies: 7
- Views: 6718
Re: Monthly Poll 201510_201511 - Do you plan to use CAFE as a replacement or supplement for Client and Why?
For now, client only though we will upgrade from 9.0 to 10.2.2 sometime next year and explore CAFE, with the hope that it will make it easier for end users to create their own reports without having to master (or not) VIEW formulae and the like. On an aside re. Citrix, I have always found it OK over...
- Wed Oct 21, 2015 12:27 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Pro & Rux file searcher
- Replies: 10
- Views: 8205
Re: Pro & Rux file searcher
Great to see these Python, REST API and other solutions. I feel all of my 62 years. The great thing about Excel and VBA from an operational point of view is that it exists in situ, in most large coprorate environments (certainly the ones I've been in), so there is a ready-made programming envrionmen...
- Mon Oct 19, 2015 10:39 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Pro & Rux file searcher
- Replies: 10
- Views: 8205
Re: Pro & Rux file searcher
.this kind of search can be done using the RestApi
Unless of course one is using TM1 v9.x. And a lot of people are still!
- Wed Oct 14, 2015 3:17 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Pro & Rux file searcher
- Replies: 10
- Views: 8205
Pro & Rux file searcher
Yet another Excel VBA TM1 text file searcher that finds: - CellPut/Gets in .Pro files (shows Tab and line no.), with option to find a cube name as well - DB( in .Rux files - Specific text *** New *** Action button property searcher PLEASE NOTE The new action button searcher requires TM1 client to be...
- Thu Sep 24, 2015 2:08 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Securing an integer using break back
- Replies: 2
- Views: 2606
Re: Securing an integer using break back
If it's only a user perception issue, you could just accept the fact that spreading will produce non-integer data, simply formatting the numbers in the cubes as integers, so that no-one will mind. In a driver-based planning context your greatest possible error would be between -1 and 1 and this woul...
- Thu Sep 17, 2015 1:26 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Feeder conundrum
- Replies: 5
- Views: 3999
Re: Feeder conundrum
I did some more experimentation and I (think) discovered the following: If you manually unload a 'source' cube (i.e. one that feeds another) from memory in v9.0, TM1 generates the feeders in the dependent cube as it unloads. Presumably by virtue of the dependency table it maintains. I tested this ma...
- Thu Sep 17, 2015 12:34 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Feeder conundrum
- Replies: 5
- Views: 3999
Re: Feeder conundrum
I know back in the day Applix made efforts to make sure rules were compiled within the cube so that is the RUX fie was destroyed by accident the rules could be recovered. It could be something to do with that? (Stretching) The only other question is do you have persistent feeders enabled?? Thanks f...
- Thu Sep 17, 2015 11:31 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Feeder conundrum
- Replies: 5
- Views: 3999
Feeder conundrum
Here's a feeder conundrum. Warning: it's a bit tedious to read through; my apologies if it's too verbose to make the point. I thought that when you unload a cube, its feeders are destroyed. Suppose then, you have two cubes joined by rule/feeder. Let's call the one with the feeder Cube1 and the one w...
- Fri Aug 21, 2015 10:23 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Scope of feeder re-setting
- Replies: 1
- Views: 1703
Scope of feeder re-setting
Apologies if this has cropped up already and been answered, or if it is a stupid question. Does anyone know if the feeder processing engine has any way of knowing, when saving a rule, what feeders are already in place as specified by that rule, and thus how to optimise feeder setting by only creatin...