You can edit a grid in BI4H starting from version 5.4.0 beta.

Before using this feature, note:

• It only works with simple grids.
• The target table cannot use the 'Log' engine.
• You need to enable the 'Allow write' option in your project's connection settings. To do this, make sure you have a role with the appropriate "Write Connection Data" permission enabled.

Once the ‘Allow write’ option is enabled, you'll see these settings in the dimension/measure and interactivity tabs:

Dimension/Measure

• Allow editing: Allow editing the relative cell
• Editing field: Set the name of the column where to save the value only if different from the one used for the table display
• Allow editing function: Conditional function to allow editing of the cell
• Primary key: whether the column is primary key (for update/delete)
• Auto Generate Key: set a Token (dataType: string)
• Auto generate username: When saving, sets the current username of the logged in user as the value (dataType: string)
• Show text area: During editing shows the input as a text area and not as a single line (dataType: string)
• Auto generate timestamp: when saving, sets the current timestamp (dateType: datetime)
• Select options data source: If in the cell edit you want to show a select with descriptions other than values that are taken from another table

Interactivity

Editing mode: 

• Row (edit row to save the entire row once)

• Cell (edit cell and save each time a value changes)

• Batch (edit multiple rows together and save when finished)

• Allow updating: allows you to perform update
• Allow adding: allows you to perform insertion
• Allow deleting: allows you to perform delete
• Allow cloning: allows you to make a copy of a row (does not work in cell mode)
• Editing table: if the table where to save is different from the one used to display the table
• Editing where condition: additional where condition to be set when performing update/insert/delete