Error: Database error:$.hbd.Connection.executeUpdate

SAP Analytics Cloud displays "Database error:$.hbd.Connection.executeUpdate: Parameter at position 1, batch element 1, value at position 1 is undefined which is not allowed

Reproducing the Issue
  1. Login to SAP Analytics Cloud.
  2. Choose Start of the navigation pathBrowse  Next navigation step DimensionsEnd of the navigation path from the main menu.
  3. Select a previously created dimension.
  4. Add a new dimension member formula that contains a dimension variable defined in the model the dimension belongs to.
  5. Select Save.
  6. Notice that the Database error message appears.
Cause

  • You will not be able to reference a model variable in a standalone dimension because variables are model-specific.

  • Model variables can only be referenced when you open the dimension within the specific model that the variable is defined in.

Resolution
  1. The dimension member formula that contains the model variable must be added to the dimension within the Start of the navigation pathBrowse  Next navigation step  ModelsEnd of the navigation path area.