Search found 104 matches

by iansdigby
Tue Sep 12, 2017 1:27 pm
Forum: Cognos TM1
Topic: Threads on TM1RunTI
Replies: 2
Views: 192

Re: Threads on TM1RunTI

Thank you David for these helpful hints.
Ian
by iansdigby
Tue Sep 12, 2017 11:59 am
Forum: Cognos TM1
Topic: Threads on TM1RunTI
Replies: 2
Views: 192

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: Cognos TM1
Topic: HTML vs Windows clients
Replies: 5
Views: 553

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: Cognos TM1
Topic: Prism?
Replies: 21
Views: 5570

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: Cognos TM1
Topic: HTML vs Windows clients
Replies: 5
Views: 553

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: Cognos TM1
Topic: HTML vs Windows clients
Replies: 5
Views: 553

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: Cognos TM1
Topic: Monthly Poll 201510_201511 - Do you plan to use CAFE as a replacement or supplement for Client and Why?
Replies: 7
Views: 1124

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: Cognos TM1
Topic: Pro & Rux file searcher
Replies: 10
Views: 1151

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: Cognos TM1
Topic: Pro & Rux file searcher
Replies: 10
Views: 1151

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: Cognos TM1
Topic: Pro & Rux file searcher
Replies: 10
Views: 1151

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: Cognos TM1
Topic: Securing an integer using break back
Replies: 2
Views: 273

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: Cognos TM1
Topic: Feeder conundrum
Replies: 5
Views: 315

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: Cognos TM1
Topic: Feeder conundrum
Replies: 5
Views: 315

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: Cognos TM1
Topic: Feeder conundrum
Replies: 5
Views: 315

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: Cognos TM1
Topic: Scope of feeder re-setting
Replies: 1
Views: 189

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...
by iansdigby
Fri Mar 06, 2015 11:36 am
Forum: Cognos TM1
Topic: ExecuteProcess with too few parameters supplied
Replies: 12
Views: 2970

Re: ExecuteProcess with too few parameters supplied

I LOVE this behavior in TM1 Execute Process. Without this, I would never EVER add a new parameter to an existing process. The list of places (Cognos Insight button, Excel worksheets action buttons, other TI processes, command line batch files in 10.2) from where processes could be called is endless...
by iansdigby
Tue Jan 13, 2015 8:55 am
Forum: Cognos TM1
Topic: Help Needed on TM1 Active Forms issue
Replies: 3
Views: 1175

Re: Help Needed on TM1 Active Forms issue

Has the user got macro security set to disable all macros?
by iansdigby
Thu Jan 08, 2015 9:16 am
Forum: Cognos TM1
Topic: Using VBA to connect to TM1 application
Replies: 22
Views: 10318

Re: Using VBA to connect to TM1 application

I am doing exactly waht smorgan is. Using a combination of techniques as advised herein by others, you should be able to get it going fairly quickly. Incude: Screenupdating=false Recalc mode=manual and do strategic calcs only where necessary Create a new workbook for each iteration Proper VIEW() fun...
by iansdigby
Mon Jan 05, 2015 3:23 pm
Forum: Cognos TM1
Topic: Cube Performance Tuning
Replies: 9
Views: 2033

Re: Cube Performance Tuning

I would examine older data in the cube to see if you can hard-copy it; thus preventing the rule from calculating loads of historic results for what is probably no useful business purpose.
by iansdigby
Fri Jan 02, 2015 4:10 pm
Forum: Cognos TM1
Topic: Consolidation vs Rule problem
Replies: 1
Views: 919

Re: Consolidation vs Rule problem

I just found this post which, though the facts are slightly different, does address it as a potential bug.

http://www.tm1forum.com/viewtopic.php?f ... 217#p53217