Writeback

Writeback allows you to either permanently edit values in the Cube (if the administrator has allowed it), or to do simple what-if analysis in Excel.

FluenceXL Excel Edition supports writeback in a number of ways through Grids, Formula-based and relational writeback. In both cases the cube itself must be write enabled.

Writeback in FluenceXL Grids

To enable writeback on an FluenceXL Grid, select FluenceXL > Properties... from the Grid right-click menu, then select the Enable Writeback option from the Writeback tab. On this tab you can also adjust a few other options, described below.

Online Entry Mode

Using Online mode, each value is submitted to the cube when typed: the value will be written and the data optionally re-retrieved (so that any aggregated data is updated straight away on the report).

By default, entry is allowed only at the leaf level of the data, as this is the most common environment.

Offline Entry Mode

In Offline mode, you can enter multiple updates at once, then submit them in one batch. To view the updates that are ready to be sent to the server, select the FluenceXL > Writeback > Manage Offline Writeback right-click menu option, and to upload the changes, select FluenceXL > Writeback > Submit Outstanding Writes.

Non-Leaf Level Writeback

When not entering data at leaf level, you must choose from the four Analysis Services spreading methods:

Method	Description
Equal allocation	Each constituent cell is assigned an equal value
Equal increment	Every constituent cell will be changed according to an incremental value
Weighted allocation	Each constituent cell will be assigned an equal value that is weighted against a formula
Weighted increment	Every constituent cell is changed incrementally according to a weighting formula

Data can then be entered for aggregate levels in the cube, and will be spread according to the rule specified.

Note that non-leaf Writeback in the Analysis Services environment should be used with caution since it can be time-consuming, depending on cube size and dimensionality.

Writeback formatting and locking

Please refer to the Writeback formatting and locking page for details on how to lock grid cells and use writeback validation rules.

Writeback and grid calculations

Please refer to the Writeback and Grid Calculations page for details on how to use Excel formulas to update the database.

Formula Writeback

There are two FluenceXL formulae which handle Analysis Services writeback: XL3DoWriteback formula and XL3LookupRW formula.

There is a dedicated formula which handles Anaplan writeback: XL3DoWriteback2.

XL3DoWriteback and XL3DoWriteback2 allow a value held in another cell to be written back to the cube whereas with XL3LookupRW the formula itself is overwritten directly.

In most cases XL3DoWriteback and XL3DoWriteback2 offer more flexibility and control.

There is also XL3RunSQL formula which is available for relational SQL updates.

Relational Writeback

In FluenceXL > Options > Workbook Options, you can specify whether to use Standard (Analysis Services) or Relational writeback. Relational writeback requires certain cube customisations, and is typically a consultancy-led process to provide additional flexibility or performance over the standard writeback processing.

Please see the main article for more information: Relational Writeback

REST Writeback

From version 2409.1 you can also select REST writeback. REST writeback will call a sprecifed http endpoint and send the writeback as a JSON payload.

Please see the main article for more information: REST Writeback