How To Fix UPF096 - Variable &1 is not restricted to a single value

UPF096 - Overview

• Message type: E = Error

• Message class: UPF - Planning Functions

• Message number: 096

• Message text: Variable &1 is not restricted to a single value

What causes this issue?

You tried to execute a formula function with a parameter group, in
which the variable &V1& is referred to. However, this variable is not
restricted to a single value, rather it contains several values or
value areas.

System Response

The function cannot be executed. The data records contained in the
planning package remain unchanged.

How to fix this error?

Check the definition of variable &V1& in the context of the current
planning area and make sure, that the variable is restricted to exactly
one single value. If you do not want to change the definition of the
variable, then create a new variable, which is restricted to a single
value, and alter the parameter group of the formula correspondingly.

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

Error message extract from SAP system. Copyright SAP SE.

UPF096 - Details

• The SAP error message UPF096 indicates that a variable (denoted as &1) is not restricted to a single value in the context of a query or report. This typically occurs in the context of SAP BW (Business Warehouse) or SAP HANA when you are trying to execute a query that requires a single value for a variable, but the variable is either set to allow multiple values or is not properly restricted.
  
  Cause:
  
  Multiple Value Selection: The variable is configured to allow multiple selections, but the query or report expects a single value.
  Default Values: The variable may have default values that are not restricted to a single entry.
  User Input: The user may have input multiple values when prompted for the variable.
  Query Design: The query design may not be set up to handle multiple values for that variable.
  
  
  Solution:
  
  
  Restrict Variable to Single Value:
  
  Go to the variable settings in the query designer or the relevant