Thursday, February 14, 2013

OBIEE 11g - Date Format change based on Locale Setting


This piece of information is a very base to locale setting.
 
When a user requested to change the date format, as the user couldnt always make the changes after downloading to excel.

So the change was to be made for the users setting instead of going globally.
 
We can either ask the user to login with the Language which is expected to produce the date format.
 
 
 
 
 
 
Else we ask the user to go the Settings-->My Account and make the below changes and finish the task and check the results.
Below is the default setting found for the user with English Language.
 
And the result would be-
 
After the changes in the My Account Setting-


The result would be-