Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Converting date format to European standard in OBIEE reports

Received Response
61
Views
4
Comments
User_JL3CW
User_JL3CW Rank 6 - Analytics Lead

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

  • [Deleted User]
    [Deleted User] Rank 10 - Analytics Guru

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

  • User_JL3CW
    User_JL3CW Rank 6 - Analytics Lead

    Hi,

    Thanks for the reply.

    As per my understanding

    Save as System-wide Default Option-

    pastedImage_0.png

    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.

  • [Deleted User]
    [Deleted User] Rank 10 - Analytics Guru

    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
    User_JL3CW Rank 6 - Analytics Lead

    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.