TM1 Performance Issue
-
- Posts: 26
- Joined: Sun Mar 10, 2019 9:06 pm
- OLAP Product: TM1
- Version: Planning Analytics 2.0
- Excel Version: Excel version 2013
TM1 Performance Issue
One of our users is experiencan issue (see attached) when trying to connect to TM1. She is using TM1 perspectives. The particular file is pulling data from a cube. Trying to understand what this means and what would cause it.
- Attachments
-
- TM1 Connectivity Issue.jpg (62.16 KiB) Viewed 3307 times
- Steve Rowe
- Site Admin
- Posts: 2410
- Joined: Wed May 14, 2008 4:25 pm
- OLAP Product: TM1
- Version: TM1 v6,v7,v8,v9,v10,v11+PAW
- Excel Version: Nearly all of them
Re: TM1 Performance Issue
This normally happens because you have a large file open pointed at a server when you try and connect to the server.
With calc on automatic or TM1REBUILDOPTION=1 there will often be a delay while the excel environment is calculated before the server explorer completes its log in.
With calc on automatic or TM1REBUILDOPTION=1 there will often be a delay while the excel environment is calculated before the server explorer completes its log in.
Technical Director
www.infocat.co.uk
www.infocat.co.uk
-
- Posts: 26
- Joined: Sun Mar 10, 2019 9:06 pm
- OLAP Product: TM1
- Version: Planning Analytics 2.0
- Excel Version: Excel version 2013
Re: TM1 Performance Issue
Thank you for your response. Very helpful.
-
- Posts: 26
- Joined: Sun Mar 10, 2019 9:06 pm
- OLAP Product: TM1
- Version: Planning Analytics 2.0
- Excel Version: Excel version 2013
Re: TM1 Performance Issue
How do I reset the TM1Rebuild Option to 0 instead of 1?
The Instructions say to do the following:
1. On the IBM Planning Analystics tab, click Options.
How do i find the IBM Planning Analytics tab?
I do not see it.
The Instructions say to do the following:
1. On the IBM Planning Analystics tab, click Options.
How do i find the IBM Planning Analytics tab?
I do not see it.
Re: TM1 Performance Issue
Hi Peter,
The TM1REBUILDOPTION is set in Excel under Formulas=>Name Manager and is attached to individual Excel sheet with TM1 Slices.
You need to set the value to 0 and save your excel report.
HTH
Ken
The TM1REBUILDOPTION is set in Excel under Formulas=>Name Manager and is attached to individual Excel sheet with TM1 Slices.
You need to set the value to 0 and save your excel report.
HTH
Ken
-
- MVP
- Posts: 3105
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.0.9.18
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: TM1 Performance Issue
Side remark. I don't use too many shortcuts in Excel but those that I use include F3:
- Ctrl-F3 = Name Manager
- F3 in a formula or conditional formatting or elsewhere brings up a dialog screen with the defined names. Useful to pick the one you need.
Wim
Best regards,
Wim Gielis
IBM Champion 2024
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
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