Converting date format to European standard in OBIEE reports

Question

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.

User_JL3CW · Answer

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.

[Deleted User] · Answer

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

User_JL3CW · Answer

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.