Cognos Analytics

 View Only

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

    #CognosAnalyticswithWatson


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

    Original Message


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

    Posted Sun October 15, 2023 10:20 AM

    Hi Dinesh,

    I am also getting an error "XQE-V5-0017 V5 syntax error found for data item 'Hostedin' of query 'Query2', invalid token "else" found after "case when ([FNMP-DW-DS].[Virtual Machine].[Located in Service Provider Datacenter]=0) then ('On-premises' ".
    CAF-WRN-2082 An error has occurred. Please contact your administrator. The complete error has been logged by CAF with SecureErrorID:2023-10-13-18:52:34.660-#12323"

    Expression query: 

    case when ([FNMP-DW-DS].[Virtual Machine].[Located in Service Provider Datacenter]=0) then ('On-premises' else 'Cloud')
    when ([FNMP-DW-DS].[Computer-General].[Computer Type] in ('computer', 'VM host')) then ('On-premises') end

    could you please help me to fix this?

    Thanks,

    Milind Teli



    ------------------------------
    Milind Teli
    ------------------------------

    Original Message


  • 4.  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
    ------------------------------

    Original Message


  • 5.  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
    ------------------------------

    Original Message


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

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

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

    Original Message