In this tutorial, you'll learn how to configure writeback settings in a planning sheet. You'll configure writeback types, apply filters, manage column mapping, configure advanced settings, and write data and scenarios back to a destination.
All writeback-related settings are available under the Writeback ribbon. You can configure different writeback options for data input columns such as formulas, numbers, notes, approval status, comments, and native columns.
Go to the Writeback ribbon.
You can configure the structure of the writeback table using the WB Type dropdown.
Select the WB Type dropdown.
Select the required writeback type:
Long – Stores one row per observation and one column for each variable.
Wide – Stores each measure in a separate column.
Long with Changes – Records changes or adjustments while storing data in the long format.
Wide with Changes – Records changes or adjustments while storing data in the wide format.
When you change the writeback type, the configured writeback destination is disabled. In the warning message, select Proceed.
Under Manage, turn on the toggle to enable the destination again.
You can apply filters to limit the data written to the destination.
Select the Filter dropdown.
Select the required filter option:
None – Writes all data without filters.
Data with comments only – Writes only rows, columns, or cells containing comments.
Calculated rows only – Writes only calculated rows to the destination.
You can rename writeback columns for measures and dimensions.
Select Mapping.
Rename the required writeback column names for measures and dimensions.
Use Settings to configure advanced writeback options.
Select Settings.
Under Date Key Configuration, select Add Date Key to write different versions to the destination.
Use the toggle to include or exclude HTML formatting for text inputs.
Select Destinations to add, edit, or delete destinations.
Select Advanced to configure data validation and rename writeback columns.
Configure data validation by either:
After configuring writeback settings, you can write data to the selected destination.
Select Writeback.
View the writeback milestones displayed in the upper-right corner.
After creating scenarios, you can write them back to the database.
Select the Writeback > Writeback All.
Select or clear the checkbox to include or exclude specific scenarios.
Select Writeback to write scenarios back to the database.
