Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Global Date format in OBIEE 12c
Hi All,
I'm facing a weird issue with one of the date column on the dashboard prompt. I have repository variable which is being used to show a default selection.
So, the problem is that format of the date column in the report is 'DD-MM-YYYY' but when I choose any date from the prompt, the format is selected like this 'MM/DD/YYYY'.
Also, I have set the NLS_DATE_FORMAT = 'DD-MM-YYYY' on the connection pool as well.
Gurus.. Is there anything that I'm missing here? Please let me know.
Thanks,
Sai Kumar
Answers
-
You can set the default display format in the column properties (when you are creating an analysis with that column in it).
It can be set for the column itself or for all columns with the same datatype.
I think your prompt values will be show in the correct format, but I didn't test it myself so not sure.
As an alternative have a look at: https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=343936076961993
0 -
I was able to identify the issue. I had to change the localedefinitions,xml config file and change the date format there.
0 -
Thanks bskumar.obiee, i added the tag in localedefinitions,xml config, but somheo it does not work for me, do you need to change anything else? thanks
0 -
Thanks Martin van Donselaar, do you know what files the changes made it written to from the backend?
Thanks
0 -
Hi @User_27DEY ,
This is a 6 years old thread, not sure it will really take you anywhere.
Post a new question providing your context (product name, exact version), what you are trying to do, what you did so far, what was the result etc.
0 -
thanks Gianni Ceresa, it is OBIEE12.2.1.4, basically we try to change the date format to DD-MMM-YYYY globally from the backend (not front end). can you please let me know how to do it to make it work? thanks,
0 -
As Gianni stated: If you have a question please open a new thread. This thread here is old and it's not yours so you can't manage it in terms of responses etc. Please move your question over to a new thread and clearly and concisely state your issue since it will be a stand-alone thread that other forum users will also want to benefit from.
0
