Remove Automatic Recalculate from View
-
- Posts: 41
- Joined: Thu Jul 07, 2011 7:50 am
- OLAP Product: TM1
- Version: 9.5.2
- Excel Version: Excel 2010
Remove Automatic Recalculate from View
I find that if i save a view with automatic recalculate turn on, then try to save it with automatic recalculate turn off, it doesn't work.
Is it a bug? Or is as intended?
Is it a bug? Or is as intended?
Server OS: Windows Server 2008 R2 (64-bit)
TM1: v9.5.2 FP1
MS Office: Microsoft Excel 2003, 2010
TM1: v9.5.2 FP1
MS Office: Microsoft Excel 2003, 2010
- Alan Kirk
- Site Admin
- Posts: 6610
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: Remove Automatic Recalculate from View
Are you talking about Cube Viewer, Web, or somewhere else?conray wrote:I find that if i save a view with automatic recalculate turn on, then try to save it with automatic recalculate turn off, it doesn't work.
Is it a bug? Or is as intended?
In Cube Viewer on my copy of 9.5.2 the automatic recalculation setting saves correctly with the view, both on and off.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-
- Posts: 41
- Joined: Thu Jul 07, 2011 7:50 am
- OLAP Product: TM1
- Version: 9.5.2
- Excel Version: Excel 2010
Re: Remove Automatic Recalculate from View
I am talking about Cube Viewer.
When i save with the option on, it works as intended, meaning the values are automatically fetched when the view is opened.
When i save with the option off, the values are also automatically fetched when the view is opened.
I wonder why.
I am on 9.5.2 FP1 now.
When i save with the option on, it works as intended, meaning the values are automatically fetched when the view is opened.
When i save with the option off, the values are also automatically fetched when the view is opened.
I wonder why.
I am on 9.5.2 FP1 now.
Server OS: Windows Server 2008 R2 (64-bit)
TM1: v9.5.2 FP1
MS Office: Microsoft Excel 2003, 2010
TM1: v9.5.2 FP1
MS Office: Microsoft Excel 2003, 2010
- Alan Kirk
- Site Admin
- Posts: 6610
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: Remove Automatic Recalculate from View
Because I do not think that the expression "automatic recalculate" means what you think it means.conray wrote:I am talking about Cube Viewer.
When i save with the option on, it works as intended, meaning the values are automatically fetched when the view is opened.
When i save with the option off, the values are also automatically fetched when the view is opened.
I wonder why.
If I may cite the 9.5.2 Reference Guide:
My emphasis; "upon view reconfiguration", not upon opening. (Which would be "calculation" rather than "recalculation".) Most people would find it annoying to open the view and immediately need to hit another command to calculate it. Not all, but most. The option is mainly there to stop you from going crazy as you drag dimensions around the view.This option enables or disables automatic recalculation upon view reconfiguration. A check mark indicates that the view is automatically recalculated whenever the view configuration changes.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-
- Posts: 41
- Joined: Thu Jul 07, 2011 7:50 am
- OLAP Product: TM1
- Version: 9.5.2
- Excel Version: Excel 2010
Re: Remove Automatic Recalculate from View
Alan, thanks for the reference.
So i guess it is impossible to stop the view from calculating upon opening it...
So i guess it is impossible to stop the view from calculating upon opening it...
Server OS: Windows Server 2008 R2 (64-bit)
TM1: v9.5.2 FP1
MS Office: Microsoft Excel 2003, 2010
TM1: v9.5.2 FP1
MS Office: Microsoft Excel 2003, 2010
- Alan Kirk
- Site Admin
- Posts: 6610
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: Remove Automatic Recalculate from View
Can't think of why you'd want to unless it's to allow the thing to be reconfigured (i.e. to allow element selection) before calculation. In that case the easiest way to do it is to create a subset which contains an element that everyone has access to but which never stores any data (even if it's a dummy element) in one of the title dimensions. That way when people open the thing they'll always see the "No Values" dialog leaving them free to select the real elements before calculating it.conray wrote:Alan, thanks for the reference.
So i guess it is impossible to stop the view from calculating upon opening it...
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-
- Posts: 7
- Joined: Wed Jan 09, 2019 7:08 am
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2013
- Location: Pune
Re: Remove Automatic Recalculate from View
Hi all,
Can you please let me know that how to create action buttons in excel.
Can you please let me know that how to create action buttons in excel.
-
- MVP
- Posts: 3126
- 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: Remove Automatic Recalculate from View
Did you really spend some very limited time to google this ? Keywords: TM1 action button
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
-
- Posts: 7
- Joined: Wed Jan 09, 2019 7:08 am
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2013
- Location: Pune
Re: Migrate from one version to another
Hi all,
Currently we are using 10.2.2 version and we are planning to migrate for Planning analytics.
So can you please let me know how to do migration.
Thanks all,
Ajay Kumar.
Currently we are using 10.2.2 version and we are planning to migrate for Planning analytics.
So can you please let me know how to do migration.
Thanks all,
Ajay Kumar.
-
- MVP
- Posts: 3664
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Migrate from one version to another
This is the 2nd time you have done it.
"It" being posting completely new and random questions in existing unrelated threads. The will not endear you other members of the community. There are certain rules of netiquette which I must say are in no way unique to this forum but are ubiquitous and exist in any internet community. For this forum for example example look here and here. You would be well served by reading these and at least making an attempt to stick to the rules. It makes life easier for everyone.
For upgrading to PA here is a very good place to start.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.