Modify formula and relational writeback options for workbooks. 

Formula writeback

OptionDescription
Enable WritebackEnables Writeback, whether or not this happens on or offline is controlled by the individual Grid Properties
Write to DataMembers in parent-child hierarchies
Allow at Lowest Level OnlyData is entered at leaf level only.
Allow at Any Level

Data entry at any level is allowed, select one of the Analysis Services Writeback spreading methods below. Note that this can be overridden at Grid Properties level:

  • 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


Lowest Level Indicators:


  • Highlight members: This highlights the members that are available for Writeback.
  • Highlight data: This highlights the data that is available for Writeback.


Relational writeback

Analysis Services is the default writeback method. However, when working with Anaplan XL or Anaplan XL Authorized partners on a consultancy basis it's also possible to use 'Relational' Writeback.

When using relational writeback, the server and database being used must be specified in the dialog above.