Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 


#Product
#Analytics
#CognosAnalytics
#Analyticstools
#TechXchange Partner
#TechXchange Session
#TechXchange Presenter
#AI
 View Only
  • 1.  XQE-PLN-0267

    Posted 03/24/20 03:52 AM
    XQE-PLN-0267 The argument at position 1 of the function 'to_date' is invalid in filter/slicer expression 'to_date([CLNDR_DT], 'YYYY-MM-DD')between _first_of_month(_add_months(current_date,-1)) and _last_of_month(_add_months(current_date,-1))'
    I am getting this error while replacing exsting packages,actually new package contains just changed views

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

    #CognosAnalyticswithWatson


  • 2.  RE: XQE-PLN-0267

    Posted 03/25/20 05:15 PM
    I would troubleshoot this by testing subsets of the full expression one at a time via new calculations.
    e.g,  test the 'to_date([CLNDR_DT], 'YYYY-MM-DD') without the rest to narrow down where the problem is.

    It's likely resolved by tweaking the syntax.


    ------------------------------
    Jason Tavoularis
    ------------------------------