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 ?
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.