Hello Forum,
I want to use an automatic refresh on a sheet in TM1 Web without using a refresh button. The sheet is a normal excel sheet not an active form, where you select values from dimensions then a launch button to launch a process.
Based on a selection of some dimensions, the other cells values should be updated automaticaly without a refresh.
What I did is I added TM1REBUILDOPTION in Name manager Set to 1. But it seem that it is not working with my drop down selection ( which also whenever I choose a value from the drop down some cells values should be updated automatically).
Is there a way to make a sheet recalculated automatically without a refresh button in TM1 Web ?
Thanks in Advance.
TM1 Web add Automatic Sheet Refresh
-
- Posts: 38
- Joined: Sun May 17, 2020 2:37 am
- OLAP Product: tm1
- Version: 10.2
- Excel Version: 2013
-
- Regular Participant
- Posts: 197
- Joined: Wed May 06, 2020 2:58 pm
- OLAP Product: Planning Analytics
- Version: 2.0.9
- Excel Version: 2016
Re: TM1 Web add Automatic Sheet Refresh
How are you generating your selections, through subnm or data validation? If its subnm then as long as automatic recalc is on when you upload the application, tm1web should change when a selection is made.
If it's a data validation list then have a look at the tm1web config. There's a setting RecalcOnDataValidationChange which if set to true will trigger a recalc when a data validation is changed.
Similar option exists for picklists as well.
Once you've made the change the Web service will need a restart
If it's a data validation list then have a look at the tm1web config. There's a setting RecalcOnDataValidationChange which if set to true will trigger a recalc when a data validation is changed.
Similar option exists for picklists as well.
Once you've made the change the Web service will need a restart
-
- Posts: 38
- Joined: Sun May 17, 2020 2:37 am
- OLAP Product: tm1
- Version: 10.2
- Excel Version: 2013
Re: TM1 Web add Automatic Sheet Refresh
Thank you for your help. I am using a calculation using data Validation where I have a condition if ( cell = 0; subnm ; show value of cell2)... I am wondering if there is any other solution that I can do so I dont have to change the config file ( Avoiding the restart as much as possible ).burnstripe wrote: ↑Mon Oct 11, 2021 6:43 pm How are you generating your selections, through subnm or data validation? If its subnm then as long as automatic recalc is on when you upload the application, tm1web should change when a selection is made.
If it's a data validation list then have a look at the tm1web config. There's a setting RecalcOnDataValidationChange which if set to true will trigger a recalc when a data validation is changed.
Similar option exists for picklists as well.
Once you've made the change the Web service will need a restart
Thank you
-
- Regular Participant
- Posts: 197
- Joined: Wed May 06, 2020 2:58 pm
- OLAP Product: Planning Analytics
- Version: 2.0.9
- Excel Version: 2016
Re: TM1 Web add Automatic Sheet Refresh
As far as I'm aware that setting is the only way to get what you require. It forces a refresh when the data validation changes, without the parameter the user will need to trigger the refresh.
Only the tm1web service will need restarting following the config change in tm1web.config, nothing else. So generally takes 5-10 minutes.
Only the tm1web service will need restarting following the config change in tm1web.config, nothing else. So generally takes 5-10 minutes.
-
- Posts: 38
- Joined: Sun May 17, 2020 2:37 am
- OLAP Product: tm1
- Version: 10.2
- Excel Version: 2013
Re: TM1 Web add Automatic Sheet Refresh
Oh I see ..if it is the tm1web so no problem. Thank you very much for your help!burnstripe wrote: ↑Wed Oct 13, 2021 9:44 pm As far as I'm aware that setting is the only way to get what you require. It forces a refresh when the data validation changes, without the parameter the user will need to trigger the refresh.
Only the tm1web service will need restarting following the config change in tm1web.config, nothing else. So generally takes 5-10 minutes.