Writeback mode

After writeback mode is enabled, you can specify new values directly in data cells. To perform writeback or splashing operations, specify new values for cells that contain an INFOR.GET.VALUE formula. The values are then written back to the database.

In future versions of Excel Integration, only the administrator can enable and disable writeback mode for specific users or groups of users. The administrator can also define whether writeback is enabled with or without splashing. In d/EPM Administration, the administrator defines a custom setting for Office Integration. The custom setting must be named WritebackBehavior and, in the Value column, must contain a value in the JSON format. For example:

{
   "D": "0",
   "Permissions":[
      {
         "ugo":["ReportDesigner","administrator","someone@somecompany.com"],
         "v":"2"
      },
      {
         "ugo":["ReportPlanner","guest"],
         "v":"1"
      }
   ]
}

The JSON string contains these elements:

• D: Defines the default behavior of writeback mode. If it contains 0, writeback is disabled for all non-specified users.
• ugo: Contains an array of specific user names, user groups, or user roles. If a user has a different permission level than a role that is assigned to that user, then user permissions prevail. If a user has multiple roles, the writeback option for the role with the highest rank prevails.
• v: Defines a writeback permission level for the specified users.

These values are used to define the default behavior of writeback mode for all non-specified users (D) and a writeback permission level for specified users (v):

• 0: Writeback is disabled.
• 1: Writeback is enabled without splashing. Writeback works on base cells. Aggregated cells are written back only if writeback rules are present. If they are not present on a rule-calculated cell or aggregated cell, writeback does not take place and a cell's original value is reverted back.
• 2: Writeback is enabled with splashing.

If "D" or "v" contain any other value than 0, 1, or 2, then writeback is disabled by default.

The custom setting name and the value in JSON format are not case sensitive.

If the administrator modifies the WritebackBehavior custom setting, the affected users are notified.

If more than one custom setting is defined with the WritebackBehavior name, the name is incremented as WritebackBehavior1, WritebackBehavior2, etc. for each setting instance. The settings with the incremented names are not used by the system even if they contain valid JSON strings. The system uses only the setting with the non-incremented name (WritebackBehavior) and a valid JSON string.

If no WritebackBehavior custom setting is defined by the administrator or if it contains no JSON string or an invalid JSON string, writeback is enabled with splashing by default.

The WritebackBehavior custom setting is used only for the client. If you have no permission to perform writeback on the server, then writeback is not performed on the server. This happens if, for example, you have only view permission for the OLAP Data Role.

When writeback rules are present, the custom settings supersede the Allow splashing on rule calculated cells setting that is configured on the Database Settings dashboard in d/EPM Administration.

OLAP writeback rules must be enabled in d/EPM Administration when writeback rules are present.

Users with view-only application roles are not subject to the WritebackBehavior custom setup.