SAP Knowledge Base Article - Public

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

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 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

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