1 Reply Latest reply on Sep 18, 2013 8:48 AM by Christian Berg

    Change Default Date Format OBIEE 11g




      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.




      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.