TM1 TI performance issues

Post Reply
vins
Posts: 35
Joined: Wed Jul 31, 2013 4:54 pm
OLAP Product: TM1
Version: 10.1
Excel Version: 2010

TM1 TI performance issues

Post by vins »

Hi Gurus!!

Please explain different steps to increase the performance of a TI Process.


Thanks !!!
declanr
MVP
Posts: 1831
Joined: Mon Dec 05, 2011 11:51 am
OLAP Product: Cognos TM1
Version: PA2.0 and most of the old ones
Excel Version: All of em
Location: Manchester, United Kingdom
Contact:

Re: TM1 TI performance issues

Post by declanr »

vins wrote:Hi Gurus!!

Please explain different steps to increase the performance of a TI Process.


Thanks !!!
It is entirely dependent on what the TI process in question is doing, I suggest you take a look at the "Request for Assistance Guidelines" for the forum.

Basic principle though is to make the process do what you want with as little work carried out as possible, this is done by making sure that your data source only covers the relevant data, when you get to the metadata/data tabs look at whether you really need to do CellGetN formulas etc within a while loop or if it is possible to just do it once before you get into the loop etc etc etc.

If you provide some detail on your ill performing process then perhaps someone will be able to advise the correct course of action.
Declan Rodger
Wim Gielis
MVP
Posts: 3241
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: TM1 TI performance issues

Post by Wim Gielis »

vins wrote:Hi Gurus!!

Please explain different steps to increase the performance of a TI Process.

Thanks !!!
Shouldn't you first hire a TM1 consultant and learn from that person during a project, and/or follow a training course in TM1?
The questions you are asking really suggest this.

Next to that, please read the guidelines on posting questions here. With so little information you can expect about everything. The result is that you get ... nothing.
Best regards,

Wim Gielis

IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
EvgenyT
Community Contributor
Posts: 324
Joined: Mon Jul 02, 2012 9:39 pm
OLAP Product: TM1
Version: PAL 2.0.8
Excel Version: 2016
Location: Sydney, Australia

Re: TM1 TI performance issues

Post by EvgenyT »

Couldnt agree more Wim..

You wont get any replies to such vague questions.. There is plenty of TM1 material that you should go through, before posting a question every time you don't know something...

ET
Post Reply