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.
![](https://docs.inforiver.com/~gitbook/image?url=https%3A%2F%2F3062809325-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FEbkCXCUXmtUq5tcnUtZE%252Fuploads%252Fudd9wg9v1ohnWab52NaK%252Fseries-wb.png%3Falt%3Dmedia%26token%3D22fdbbf3-5ce5-4a87-aeac-8e19b019fee4&width=768&dpr=4&quality=100&sign=19c890a2&sv=1)
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.
![](https://docs.inforiver.com/~gitbook/image?url=https%3A%2F%2F3062809325-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FEbkCXCUXmtUq5tcnUtZE%252Fuploads%252FRXs8WxfReGU2dtteVQeW%252F3.3.%2520Writeback%2520exclude%2520dimension%2520row%2520dimension%2520ID%2520mapping.png%3Falt%3Dmedia%26token%3D1dab8eb9-9d83-4916-9bba-fdaea17305d4&width=768&dpr=4&quality=100&sign=7b535a43&sv=1)
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.
![](https://docs.inforiver.com/~gitbook/image?url=https%3A%2F%2F3062809325-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FEbkCXCUXmtUq5tcnUtZE%252Fuploads%252Fiv55Ltv1sDBwqH39MQSR%252F3.4.%2520Writeback%2520exclude%2520dimension.png%3Falt%3Dmedia%26token%3Dd34ba203-e221-41fd-b7bc-bf1ce0ac1eea&width=768&dpr=4&quality=100&sign=fd5d6f3a&sv=1)
The product name field is not written back. You can distinctly locate a row using the product ID field.
![](https://docs.inforiver.com/~gitbook/image?url=https%3A%2F%2F3062809325-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FEbkCXCUXmtUq5tcnUtZE%252Fuploads%252FDI6zf1fYmfG0eMKWAxRD%252F3.5.%2520Writeback%2520exclude%2520dimension%2520target%2520data.png%3Falt%3Dmedia%26token%3D76175220-71ef-4f30-969a-795ee285e0c5&width=768&dpr=4&quality=100&sign=98243975&sv=1)
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.
![](https://docs.inforiver.com/~gitbook/image?url=https%3A%2F%2F3062809325-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FEbkCXCUXmtUq5tcnUtZE%252Fuploads%252FgzXTaSXBv3Y0YqzFNjHI%252Fauto-wb.png%3Falt%3Dmedia%26token%3D5acef223-e523-4ed6-a1d5-7d8463ab1fa6&width=768&dpr=4&quality=100&sign=262cab4f&sv=1)
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.
![](https://docs.inforiver.com/~gitbook/image?url=https%3A%2F%2F3062809325-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FEbkCXCUXmtUq5tcnUtZE%252Fuploads%252F6PJUF0VtenvSarO9dmqH%252Fimage.png%3Falt%3Dmedia%26token%3D490415b2-8998-4c06-aa4b-8c5dda80aeaa&width=768&dpr=4&quality=100&sign=43ac2b77&sv=1)
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:
![](https://docs.inforiver.com/~gitbook/image?url=https%3A%2F%2F3062809325-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FEbkCXCUXmtUq5tcnUtZE%252Fuploads%252FiSEXU4eqJWkx6DiCXisj%252Fimage.png%3Falt%3Dmedia%26token%3Db9775464-c265-45a1-a6e7-0d53d25f0c22&width=768&dpr=4&quality=100&sign=bfd66a26&sv=1)
Updated benchmark value of EURIBOR with the dependent rate auto-written back to the destination:
![](https://docs.inforiver.com/~gitbook/image?url=https%3A%2F%2F3062809325-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FEbkCXCUXmtUq5tcnUtZE%252Fuploads%252FeQwzx0VRvl2o8mxwikkC%252Fimage.png%3Falt%3Dmedia%26token%3D2f4ddf40-3a50-452f-90c1-636c32cb04fa&width=768&dpr=4&quality=100&sign=8fb900e6&sv=1)
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.
![](https://docs.inforiver.com/~gitbook/image?url=https%3A%2F%2F3062809325-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FEbkCXCUXmtUq5tcnUtZE%252Fuploads%252F5oANOLTTYqhHVE9U8kN8%252Fscenario-wb.png%3Falt%3Dmedia%26token%3D5c174a99-32e8-4e70-b04b-5f51d9dc3b20&width=768&dpr=4&quality=100&sign=fe8dbfb0&sv=1)
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.
![](https://docs.inforiver.com/~gitbook/image?url=https%3A%2F%2F3062809325-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FEbkCXCUXmtUq5tcnUtZE%252Fuploads%252FRqQDFtc9RjwP5zVOpGQx%252Fimage.png%3Falt%3Dmedia%26token%3D540e17b7-7466-4604-afa0-e33a07c97f08&width=768&dpr=4&quality=100&sign=4dc3eac5&sv=1)
Last updated