Cognos Analytics

Expand all | Collapse all

XQE-V5-0017 V5 syntax error

  • 1.  XQE-V5-0017 V5 syntax error

    Posted Tue July 14, 2020 03:19 AM
    XQE-V5-0017 V5 syntax error found for data item 'Final Cmplt Date' of query 'Interims Raw Data', invalid token "when" found after "case
    when ([Business Layer].[Dim Logistics Delivery Parameter].[UNSCCS_DLVRY_DT] is not null)
    then ([Business Layer].[Dim Logistics Delivery Parameter].[UNSCCS_DLVRY_DT]

    ".
    CAF-WRN-2082 An error has occurred. Please contact your administrator. The complete error has been logged by CAF with SecureErrorID:2020-07-14-07:01:14.083-#539


    Can anyone please help me in resolving this error.

    ------------------------------
    Priyanka Joshi
    ------------------------------


  • 2.  RE: XQE-V5-0017 V5 syntax error

    Posted Tue July 14, 2020 03:30 AM
    Dear@Priyanka Joshi,

    The error indicates ​problem with expression defined in the particular data item i.e. Final Cmplt Date.

    Kindly share complete expression for further advice.

    ------------------------------
    Dinesh K. Dhiman
    BI Architect,
    IBM Data and AI Experts Labs | India Software Lab Services
    ------------------------------



  • 3.  RE: XQE-V5-0017 V5 syntax error

    Posted Tue July 14, 2020 04:18 AM
    case
    when ([Business Layer].[Dim Logistics Delivery Parameter].[UNSCCS_DLVRY_DT] is not null)
    then ([Business Layer].[Dim Logistics Delivery Parameter].[UNSCCS_DLVRY_DT]

    when ([Business Layer].[Dim Logistics Delivery Parameter].[UNSCCS_PICKUP_DT] is not null)
    then ([Business Layer].[Dim Logistics Delivery Parameter].[UNSCCS_PICKUP_DT])
    else ([Business Layer].[Dim Logistics Delivery Parameter].[CNCL_DT])

    end

    ------------------------------
    Priyanka Joshi
    ------------------------------



  • 4.  RE: XQE-V5-0017 V5 syntax error

    Posted Tue July 14, 2020 04:21 AM
    Hi Priyanka,

    Right parenthesis missing on 2nd line.
    Please try following expression.

    case
    when ([Business Layer].[Dim Logistics Delivery Parameter].[UNSCCS_DLVRY_DT] is not null)
    then ([Business Layer].[Dim Logistics Delivery Parameter].[UNSCCS_DLVRY_DT])

    when ([Business Layer].[Dim Logistics Delivery Parameter].[UNSCCS_PICKUP_DT] is not null)
    then ([Business Layer].[Dim Logistics Delivery Parameter].[UNSCCS_PICKUP_DT])
    else

    ([Business Layer].[Dim Logistics Delivery Parameter].[CNCL_DT])

    end

    Thanks

    ------------------------------
    Dinesh K. Dhiman
    BI Architect,
    IBM Data and AI Experts Labs | India Software Lab Services
    ------------------------------



  • 5.  RE: XQE-V5-0017 V5 syntax error

    Posted Tue July 14, 2020 07:28 AM
    It worked .

    ------------------------------
    Priyanka Joshi
    ------------------------------