1 Reply Latest reply: Sep 18, 2013 3:48 AM by Christian Berg RSS

    Change Default Date Format OBIEE 11g

    user11173172

      Hello

       

      I am trying to change the default DATE format displayed in OBIEE 11g Presentation Reports, by adding  the below command in RPD > Connection Pool > Connection Scripts tab > Execute on Connect

      CAST SUPPORTED feature is also checked in Database features.

       

           ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MM-YYYY' 

       

      But I still see the old default format 'MM/DD/YYYY', in front end reports

       

      As there are multiple connection pools in our RPD, this date format needs to be applied to only one specific Connection Pool.

      So I cannot apply as a global default date format by editing config files.

       

      Has any one succeeded using above ALTER SESSION command in RPD to change date format ?

       

      Thank you

        • 1. Re: Change Default Date Format OBIEE 11g
          Christian Berg

          ALTER SESSION in the connection pool has nothing to do with the GUI. It's the technical represenation of your physically stored dates...i.e. back-end.

           

          Front-end is controlled by the OBIPS (not OBIS) settings for the different localization = locales! If it's only for one specific subject area, you can also simply define system-wide defaults for the data-type columns wihtin that SA.