General OBIEE

Get Involved. Join the Conversation.


    Brenda Jacks
    OTBI Variable Presentation Date Prompt Format DD-MON-YYYY
    Topic posted May 15, 2017 by Brenda JacksSilver Medal: 2,000+ Points, tagged Analyses, Core HR, Customizing Reports, Fusion, OBI Answers, OBIEE Answers, OTBI, SQL 
    640 Views, 1 Comment
    OTBI Variable Presentation Date Prompt Format DD-MON-YYYY
    Users need to be able to enter a date in DD-MON-YYYY format at the prompt

    Our date format changed to dd-MON-yyyy (15-MAY-2017), but the only way the report runs is if the date is entered in DD-MM-YYYY format (15-05-2017) at the prompt.  Is there a way to change this so the user can enter dd-MON-yyyy?






    • Richard Chan
      1. Go to the directory $ORACLE_HOME/bifoundation/web/display/localedefinitions.xml
      2. Take a back up of the file localedefinitions.xml.
      3. Open localedefinitions.xml to edit  , Find<localeDefinition name="en"> 
      4. Replace below properties with appropriate value
        • <property name=”dateShortFormat”>dd-MON-yyyy</property>
        • <property name=”dateOrder”>dmy</property>
      5. Restart the services