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:
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...
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.
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
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.