Variable 0CMONTH for characteristic Cal. year / month has been converted to a required entry
I am getting below message when I execute the query in production environment and query doesnt execute.
The same query in development and Quality system is running fine.
for characteristic Cal. year / month has been converted to a required entry
Message no. BRAIN045
In the following cases, an optional entry for 0CMONTH is not possible:
■0CMONTH is used in a selection row with exclude (SIGN = E).
■0CMONTH is used in a selection row where the operator is not EQ or BETWEEN.
■The selection row is an interval and both the From value and To value are optional variables
■The selection is a structure element (FEMS > 0) and consists of several selection rows with include (SIGN = I) for the same characteristic
The variable0CMONTH is set as a mandatory entry in this query.
If you can permit the mandatory entry setting, you do
not have to perform any further steps.
Alternatively, you can use an optional interval
variable. You can also define two or more (hidden) selection elements, which
you merge with a formula element.
Need your expert advice as in why this issue is occurring in production landscape and not in development and Quality?
Thanks very much in advance!!