Symptom
Getting error Unexpected word '@' or ')' or '' when displaying a query in Custom Analytical Query app that one of the column has a negative value for example day range that is computed by a formula.
Environment
SAP S/4HANA Cloud Public Edition 1805
Reproducing the Issue
-
Create a CDS view
- One of the field is computed by creating a formula that deals with Days
- The result generates in one of the rows a negative value
- This will cause the error
Cause
A dimension cannot return negative values.
Resolution
The formula needs to be adjusted to not allow to return a negative value and it should be positive.
Keywords
error word '@', KPI analytical query unexepcted error , KBA , BC-SRV-APS-EXT-AQD , Fiori based Query Designer , Problem
Product
SAP S/4HANA Cloud 1805