Categories
- All Categories
- 104 Oracle Analytics News
- 9 Oracle Analytics Videos
- 14.3K Oracle Analytics Forums
- 5.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 58 Oracle Analytics Trainings
- 60 Oracle Analytics Data Visualizations Gallery
- 5 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
Converting date format to European standard in OBIEE reports

Hi All,
How to convert date format in all the reports of web catalog from current format (MM/DD/YYYY) to European standard (DD/MM/YYYY or DD-MON-YYYY)
Currently i have done for one report at column level. It's difficult to do manually to all the reports (more than 100 reports).
Is there configuration at system level in such a way that all the reports get effected (date format) or any other approach please advice.
I am working on OBIEE 11.1.1.7 version (On Premise) on APCC (ORACLE APPLICATIONS).
Regards,
Chandra.
Answers
-
1.) Read about localization: https://docs.oracle.com/cd/E23943_01/bi.1111/e10541/deploylocal.htm#BIESG1409
Every locale (not language) has its own settings and for example GERMAN has different date pictures than FRENCH or ENGLISH ... there are as many locales for Europe as there are countries; actually more. so "European standard"...yeah that's not DD/MM/YYYY
2.) So if the language doesn't solve your issue then you might read another part of the documentation:
https://docs.oracle.com/middleware/11119/biee/BIEBB/raas-analyses006.htm
See that "Save as the system-wide default for this column" in the table? Read what it does.
It's always helpful to read the documentation. It's perfectly available and searchable through google. First link is the FRIST result for the query https://www.google.com/search?q=obiee+language+settings
Second link is the second result (because first is the cloud version and probabaly would raise a complaint) of this query: https://www.google.com/search?q=obiee+column+format+default
Technology in 2017 is magic...
0 -
Hi,
Thanks for the reply.
As per my understanding
Save as System-wide Default Option-
I think the third option will work for all the date columns with catalog will change, once i change in a particular report date column formatting to dd/MM/yyyy and set it to 3rd option in the above screen shot. Please confirm.
Regards,
Chandra.
0 -
Well in all simplicity: yes. Question is: SHOULD that be what you are going to do? You don't seem to have thought about that "WHY" at all. But just to force the different format, sure. You'll just change everything for everyone without distinction
0 -
Hi,
I just need to change the format of all the date columns to dd/mm/yyyy in all reports in the catalog.
I think it will not effect the date calculations (in column formula) and report level filters on date.
Will it change all date columns formatting, once i change on a particular date column formatting in a report and set it as "Save as the system-wide default for this data type". Please confirm.
Regards,
Chandra.
0