I use Brio 8.3 Hyperion Intelligence Explorer. Currently all the date fields is displaying as DD-MM-YY format. I would like to have them pulled in DD-MM-YYYY ie year in 4 digit format.Can you advice how to do it?
Appreciate your early response. I searched in oracle community for this and could not get any help/reference on this. Hence thought of asking here..
I tired to change the datatype to Long text, date, string etc, but not getting desired result. When I pulled with datatype as =string, It displayed as YYYY creating issues when exporting to spreadsheet . I would like to have to date format showing up as DD-MM-YYYY or MM-DD-YYYY or YYYY-DD-MM provided the its a recognizable date format with 4 digit year.