Custom Date format in the Dashboard Prompts IN OBIEE

Change the Custom Date format in the Dashboard Prompts

How to Set default My Account -> User ->Performance : Locale , Time Zone and Language and Analytics’s Calendar default Date format

  1. To set default User -> Preference -> location modify the
    <MIDDLEWARE_HOME>/Oracle_BI1/bifoundation/web/display/localemappings.xml
    Replace
    <when matches=”en*”><localeDefinition name=”en-us”/></when>    With
   <when matches=”en*”><localeDefinition name=”en-au”/></when>
  1. To set the Time Zone  and Data Time Zone Offset , add the following entries in instanceconfig.xml
    <TimeZone>

         <DefaultDataOffset>600</DefaultDataOffset>

         <Logging>(GMT+10:00) Canberra, Melbourne, Sydney</Logging>

         <DefaultUserPreferred>(GMT+10:00) Canberra, Melbourne, Sydney</DefaultUserPreferred>

         <DefaultDataDisplay>(GMT+10:00) Canberra, Melbourne, Sydney</DefaultDataDisplay>

    </TimeZone>

    For more details:  Oracle® Fusion Middleware System Administrator’s Guide for Oracle Business Intelligence Enterprise Edition 11g Release 1 (11.1.1) -15 Configuring Time Zones
  2. To restrict the location and language for account  (Drop down list of location and language) add entries in instanceconfig.xml :
    <Localization>

    <AllowedLanguages>en</AllowedLanguages>
    <AllowedLocales>en-au</AllowedLocales>
    </Localization>
  3. To set Default calendar Date formatting
    <MIDDLEWARE_HOME>/Oracle_BI1/bifoundation/web/display/localedefinitions.xml :
    Replace below properties with appropriate value
    <property name=”dateShortFormat”>d/MM/yyyy</property>

    <property name=”dateOrder”>dmy</property>
Posted by