SAP Knowledge Base Article - Public

2647142 - Error unexpected word '@' or ')' when previewing Analytical Auery


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.


SAP S/4HANA Cloud 1805

Reproducing the Issue

  1. Create a CDS view
  2. One of the field is computed by creating a formula that deals with Days
  3. The result generates in one of the rows a negative value
  4. This will cause the error


A dimension cannot return negative values.


The formula needs to be adjusted to not allow to return a negative value and it should be positive.


error word '@', KPI analytical query unexepcted error , KBA , BC-SRV-APS-EXT-AQD , Fiori based Query Designer , Problem


SAP S/4HANA Cloud 1805