How to avoid auto recalculate when using DBSW in Perspective

[emotlau]

aa.jpg (40.35 KiB) Viewed 5280 times

Hi,

I am using Perspective to populate data using DBRW and DBSW to copy data. The purpose of this is to allow user to copy data from column 'Source' into column 'To'.
The problem is how to avoid the data from automatically being updated the cube view until user click on button or F9 key.
I have tried to set the calculation to be Manual. However, if I select Manual then the cube will not get updated even after i hit F9 key. Did i miss out anything?

Please help.

Thank you.

[Martin Ryan]

I use a "send" flag so that the user can determine when they want to send the value. If the flag is set to no it just shows an "x". E.g.
=if($A$1="Y", DBS(value, cube, etc etc), "x")

HTH,
Martin

[emotlau]

I use a "send" flag so that the user can determine when they want to send the value. If the flag is set to no it just shows an "x". E.g.
=if($A$1="Y", DBS(value, cube, etc etc), "x")

Woww!!! a perfect solution for me. Thanks Martin

[lewerner]

Hello all,
I have the same problem using DBSW in Perspective, but additionally I want to publish my sheet in TM1 Web, after I created it in Excel.
In Excel Martins solution works fine, but TM1 Web seems to recalculate the whole sheet every time you perform an action concerning a checkbox, pick list or radio button. The recalc is not the real problem here, but every time TM1 Web recalculates the sheet a save dialog pops up. It is quite annoying being asked to save, every time you check or uncheck a checkbox.
Is there a workaround to avoid autorecalc in TM1 Web, too? (or at least this save dialog?!?)

"RecalcWebsheetOnActivate" is set to false and deactivating the autorecalc button in Tm1 Web seems to have no effect either.

Code: Select all

    <!-- If true,  recalc will be performed each time websheet is activated, e.g switching tabs. -->
<add key="RecalcWebsheetOnActivate" value="false" />

Thanks for your replies!

[Andy Key]

To block the Save message have a look in your web.config for the SuppressPleaseSaveDialog key.

<!-- Disables "Please Save" dialog and automatically submits any changed data, prior to performing an action such as data spreading or pick-lists which triggers a recalc
0 - Indicates that the dialogs will not be suppressed
1 - Indicates that the dialogs will be supressed-->
<add key="SuppressPleaseSaveDialog" value="1" />

[lotsaram]

To block the Save message have a look in your web.config for the SuppressPleaseSaveDialog key.

<!-- Disables "Please Save" dialog and automatically submits any changed data, prior to performing an action such as data spreading or pick-lists which triggers a recalc
0 - Indicates that the dialogs will not be suppressed
1 - Indicates that the dialogs will be supressed-->
<add key="SuppressPleaseSaveDialog" value="1" />

Andy you are my hero! Never noticed this before. This is becoming standard in all my web servers as of today.

However this key isn't currently included in the OOTB web.config
So question: can it go anywhere in the <appSettings file="tm1web.config"> region or is there somewhere specific it needs to go?

[Andy Key]

So question: can it go anywhere in the <appSettings file="tm1web.config"> region or is there somewhere specific it needs to go?

Sorry, been overseas with no Internet for a while. I'm sure you've already worked it out by now, but I guess it can go anywhere in that region, I put it at the bottom along with the other newer keys.