Search found 109 matches

by iansdigby
Wed Dec 11, 2019 1:56 pm
Forum: Useful code, tips and tricks
Topic: Cryptic TM1 Messages Decoded
Replies: 71
Views: 368933

Re: Cryptic TM1 Messages Decoded

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?'
by iansdigby
Tue Nov 19, 2019 3:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: DBRW vs DBR in PAx
Replies: 2
Views: 2852

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...
by iansdigby
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: 7477

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...
by iansdigby
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: 12136

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...
by iansdigby
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: 13105

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
by iansdigby
Tue Sep 12, 2017 1:27 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Threads on TM1RunTI
Replies: 2
Views: 2591

Re: Threads on TM1RunTI

Thank you David for these helpful hints.
Ian
by iansdigby
Tue Sep 12, 2017 11:59 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Threads on TM1RunTI
Replies: 2
Views: 2591

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 ...
by iansdigby
Wed Nov 11, 2015 1:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: HTML vs Windows clients
Replies: 5
Views: 4215

Re: HTML vs Windows clients

many of us got into this game because we like learning cool new technologies anyway.
Yes!

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.
by iansdigby
Tue Nov 10, 2015 2:33 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Prism?
Replies: 21
Views: 16400

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.
by iansdigby
Tue Nov 10, 2015 12:10 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: HTML vs Windows clients
Replies: 5
Views: 4215

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 ...
by iansdigby
Mon Nov 09, 2015 10:40 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: HTML vs Windows clients
Replies: 5
Views: 4215

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...
by iansdigby
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: 6604

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...
by iansdigby
Wed Oct 21, 2015 12:27 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Pro & Rux file searcher
Replies: 10
Views: 8106

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...
by iansdigby
Mon Oct 19, 2015 10:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Pro & Rux file searcher
Replies: 10
Views: 8106

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!
by iansdigby
Wed Oct 14, 2015 3:17 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Pro & Rux file searcher
Replies: 10
Views: 8106

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...
by iansdigby
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: 2567

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...
by iansdigby
Thu Sep 17, 2015 1:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeder conundrum
Replies: 5
Views: 3956

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...
by iansdigby
Thu Sep 17, 2015 12:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeder conundrum
Replies: 5
Views: 3956

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...
by iansdigby
Thu Sep 17, 2015 11:31 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeder conundrum
Replies: 5
Views: 3956

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...
by iansdigby
Fri Aug 21, 2015 10:23 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Scope of feeder re-setting
Replies: 1
Views: 1676

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