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.

2. Dimensions to be removed from writeback

Inforiver provides a Row Dimension ID Mapping feature that enables you to choose the dimensions to uniquely identify a row. For instance, you can identify a product using just the product ID instead of the product name.

Row dimension ID mapping

Since the Row Dimension ID Mapping is set up based on the Product ID, the Product Name is redundant and can be dropped from writeback. You can use the dropdown to select the dimensions to be removed.

Removing the product ID dimension from writeback

The product name field is not written back. You can distinctly locate a row using the product ID field.

Data in the snowflake destination

3. 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.

This option can be enabled only after configuring a 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.

Dependant forumla 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:

Autowriteback 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.

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

5. Writeback as plain text or as text with Html tags

You can now include your HTML content within the Text data input column as well as in DAX measures, which can be written back by enabling or disabling the 'Show Text Input with HTML Formatting'. To know more please click here.

Show Text Input with HTML Formatting - toggle.