Data Settings
Last updated
Was this helpful?
Reporting & Writeback Matrix Docs
Last updated
Was this helpful?
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.
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.
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.
The product name field is not written back. You can distinctly locate a row using the product ID field.
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 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.
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:
Updated benchmark value of EURIBOR with the dependent rate auto-written back to the destination:
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.
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.
Inforiver provides a 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.
This option will be displayed only if you have created a scenario. You can read more on how to create a scenario .
