Cognos Analytics

 View Only
Expand all | Collapse all

DEF-0426 The function 'to_date' is not available in Function Set Id 'V_MSAccess'

  • 1.  DEF-0426 The function 'to_date' is not available in Function Set Id 'V_MSAccess'

    Posted Mon April 15, 2019 07:24 AM
    Dear Cognos Experts,

    We are using C13.0.11 Interim Fix 9 and I see the following error in a report (full interactivity) that I
    copied over from C10 to C11.

    -DEF-0426 The function 'to_date' is not available in Function Set Id 'V_MSAccess'. Specify a Function Set Id on the appropriate data source in the model.

    The expression editor help shows me that there is a to_date function but somehow it does not get used well
    We used DB2 as an underlying DB.

    Does someone know what I can do? We use the date format dd.mm.yyyy

    Query filter expression:
    [ourdate >= to_date(?pSelectedDate?; 'DD.MM.YYYY')

    ------------------------------
    P Smith
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: DEF-0426 The function 'to_date' is not available in Function Set Id 'V_MSAccess'

    Posted Mon April 15, 2019 10:22 AM

    Hello,
    The Cognos Analytics version seems to be incorrect, is it maybe CA11.0.1 R9 ? However, that's not that important. The error message starts with '-DEF-0426', did it have CQE in front of that, i.e. did it start with 'CQE-DEF-0426' ? If the answer is yes to that, then it seems that the report that you're using is referring to an FM Package that was published with a restricted vendor set of functions. In FM you can edit the package definition and add DB2 as an additional set of functions that you need. Then you'd need to republish the FM Package.
    The example that you give for using the to_date function, if the parameter value is in the correct format, then it should work. E.g. to_date('23.03.2019'; 'DD.MM.YYYY') works fine for me.
    //Henk



    ------------------------------
    HENK CAZEMIER
    ------------------------------

    Original Message


  • 3.  RE: DEF-0426 The function 'to_date' is not available in Function Set Id 'V_MSAccess'

    Posted Tue April 16, 2019 11:19 AM
    Hi Henk,

    Thanks for your reply. The error message just reads "QE-DEF-0426".
    Maybe the C is cut off?

    Thanks, I will try the FWM settings today.

    ------------------------------
    P Smith
    ------------------------------

    Original Message