Hi Gurus!!
Please explain different steps to increase the performance of a TI Process.
Thanks !!!
TM1 TI performance issues
-
- 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
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.vins wrote:Hi Gurus!!
Please explain different steps to increase the performance of a TI Process.
Thanks !!!
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
-
- 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
Shouldn't you first hire a TM1 consultant and learn from that person during a project, and/or follow a training course in TM1?vins wrote:Hi Gurus!!
Please explain different steps to increase the performance of a TI Process.
Thanks !!!
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
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
-
- 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
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
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