Writeback mode

By default, writeback mode is disabled for all users. The administrator can enable and disable writeback mode for specific users, groups of users, or all users. The administrator can also define whether writeback is enabled with or without splashing by defining a custom setting for Office Integration in EPM Administration. The custom setting must be named WritebackBehavior and, in the Value column, the administrator specifies one of these values:

• 0

  Writeback is disabled for all users.

• 1

  Writeback is enabled without splashing for all users.

• 2

  Writeback is enabled with splashing for all users.

• A value in the JSON format

  Used for specific user names, user groups, or user roles. 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.

  The default behavior of writeback mode for all non-specified users (D) and a writeback permission level for specified users (v) is defined with one of these values:

  • 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.

  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 or simple value 0, 1, or 2. The system uses only the setting with the non-incremented name (WritebackBehavior) and a valid JSON string or simple value 0, 1, or 2.

If no WritebackBehavior custom setting is defined or if it contains no value or an invalid value, then writeback and splashing are disabled.

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 EPM Administration.

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

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

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.