Most of the times when we are dealing with dates we end up in a situation where we have to decide whether to go for a date or date time. For sure you know the situation having a date field like Order Date which provides date information in Date Time format. In such a case the user should be able to decide if Date or Date Time format is used, because both possibilities may apply.
Thus, your OBIEE application will provide those date fields in Date Time format. Otherwise users won't be able to access the time information. Date data format for reports not needing time information needs to be changed via Column Properties.
When implementing reports for users using Oracle BI in different languages you will lose locale settings if you select a specific date format, e.g. MM/DD/YYYY or any other from the date format list below.
To avoid lose of locale setting select Custom and insert as Custom Date Format:
[FMT:dateShort]
When implementing reports for users using Oracle BI in different languages you will lose locale settings if you select a specific date format, e.g. MM/DD/YYYY or any other from the date format list below.
To avoid lose of locale setting select Custom and insert as Custom Date Format:
[FMT:dateShort]
Tip: If you just want to see time information use [FMT:time]. Run your report, go to My Account, change the locate and reload OBIEE analysis results. Date format appears in locale selected.
Hi Rampradeep,
ReplyDeleteThank You for sharing Obiee valuable information and Knowledge.
I'm preparing these issues and using analytics links. But those links are not working from few days back. Please verify the problem, if problem is your side.
Thanks,
Chandra.