You can use the followoing advanced parameters in your Workbook in order to realize advanced planning functionality. Please remember that all named ranges in data1.io must be defined on a sheet (and not workbook) level.

The most important

The following optional parameters can be used to realize advanced planning functionality:

• data1_Write_AlwaysOn
• data1_IsWriting

How to use the advanced planning parameters

data1_Write_AlwaysOn

This parameter can have two values:

• 0 = normal behaviour
• 1 = write button will be enabled- only on bottom level elements
• 2 = write button will be enabled - also on sum level elements

You can use this parameter to force the availability of the write button although otherwise the button would be deactivated (e.g. presence of exclusively read-only cells, presence of exclusively level queries, presence of alternative bottom level queries, etc.). Please be aware that the write button can be forced only within the valid period of the current workflow.

data1_IsWriting

This parameter can have two values:

• 0 = no Write process is currently executed
• 1 = Write process is currently executed

You can use this parameter e.g. to set alternative dimension keys for the WRITE process other than for the READ process. The current status of this parameter is derived from all CELLS0x areas on the sheet.