Business Analytics

XQE-PLN-0267

  • 1.  XQE-PLN-0267

    Posted Mon March 23, 2020 04:12 AM
    Hi All,
    I have modified my curent report package and when I refreshed that my report showing 

    XQE-PLN-0267 this error for to_date function.
    XQE-PLN-0267 The argument at position 1 of the function 'to_date' is invalid in filter/slicer expression 'to_date([Business View].[DIM_DT].[CLNDR_DT], 'YYYY-MM-DD')between _first_of_month(_add_months(current_date,-1)) and _last_of_month(_add_months(current_date,-1))' of query 'Summary Query', expected one of the following types: 'string, integer'.
    XQE-PLN-0267 The argument at position 1 of the function 'to_date' is invalid in filter/slicer expression 'to_date([Business View].[DIM_DT].[CLNDR_DT], 'YYYY-MM-DD')between _first_of_month(_add_months(current_date,-1)) and
    _last_of_month(_add_months(current_date,-1))' of query 'Summary Query', expected one of the following types: 'string, integer'.
    Can anyone please help me on this.



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