6 Replies Latest reply on Apr 11, 2016 1:58 PM by SriniVEERAVALLI

    Convertion of WID column to date column in BMM layer

    Helan Kumar

      TO_DATETIME(CAST ("Oracle Data Warehouse"."Catalog"."dbo"."Dim_W_DAY_D_Common"."CAL_WEEK_START_DT_WID" AS CHAR), 'YYYY-MM-DD')

       

      is failing with below error(screenshot). The report query generated will work in SQLDevloper if i remove distinct from the sql. Please guide me in handling this.

       

      Basically i have an wid column (format 20160407 i.e., YYYYMMDD) need to be displayed in date format and this has to be done in RPD, because user needs it for adhoc reporting.

       

      Untitled.jpg