Data Settings

Under the data settings, you can view a list of all the series configurations. Here you can select the series that should be included in the writeback.

1. Series allowed for writeback

This section will list all the possible series that are allowed for writeback. All the series are selected by default. You can select/unselect the series you want to write back to the destination.

Series allowed for writeback

2. Auto writeback for database destination

If you enable auto writeback, the chosen series and scenario(s) will be written back automatically without having to initiate the writeback operation manually. Writeback will be triggered periodically after specified intervals. It can be enabled from the Data settings and the Writeback toolbar

This option can be enabled only after configuring a database destination.

• Auto-writeback will be triggered only if you make adjustments to data input fields or simulations, not native values.

Auto writeback

Auto-writeback can also capture changes to dependent measures. For instance, consider that you have a data input field whose values are used to drive a formula field. In this report, we’ve derived the Rate based on the Benchmark, a data input text column.

Dependent formula measure

The benchmark for the Furniture row was updated from LIBOR’ to ‘EURIBOR’ and captured during auto-writeback. Notice how the change in rate was also automatically written back.

Initial value of LIBOR with the corresponding rate written back to the destination:

Initial writeback

Updated benchmark value of EURIBOR with the dependent rate auto-written back to the destination:

Auto- writeback triggered when the benchmark was updated

3. Scenarios to be included for auto writeback

This option will be displayed only if you have created a scenario. You can read more on how to create a scenario here.

In this section, you will find a list of all the created scenarios. You can select the scenario(s) you want to write back. Please note, if you do not have any scenarios and auto writeback is enabled, only the data input columns will be auto-written back when changes are made to the base table. Native columns will not be auto-written back even when modified.

Scenarios for Auto Writeback

4. Advanced settings

You can set the time interval between consecutive auto-writebacks in the Advanced section. The default delay is set to 5 seconds. This time interval can be decreased, with a value of 0 resulting in the immediate triggering of writebacks.

The time interval between auto-writebacks can be set for non-numeric data only.

Auto write back debounce time