Reporting and Analytics for SCM

Get Involved. Join the Conversation.

Topic

    Sanjay Shah
    Changing date format from 2018-07 to Jul-2017
    Topic posted December 4, 2018 by Sanjay ShahGreen Ribbon: 100+ Points, tagged Business Intelligence, OBIEE Answers, OTBI, Procurement 
    98 Views, 2 Comments
    Title:
    Changing date format from 2018-07 to Jul-2017
    Summary:
    Changing date format from 2018-07 to Jul-2017
    Content:

    ello,
      What is the syntax to change from Time Dimension Month Code from 2018-07 to Jul-2017.  When I try to change in column properties it does not like it.

    Thanks for your help.

    Version:
    r13

    Comment

     

    • Tim Beard

      Hi Sanjay,

      Have a look at the task "Global Admin Preferences" in Setup and Maintenance. Here you can set the date default format for all users. For an individual user, click on the user in the top-right of the screen and select Set Preferences.

      Hopefully this achieves what you're looking for.

      Tim

       

    • Sanjay Shah

      Thanks Tim for the reply.  I am looking for specifically the time dimension for Calendar Month Code.  as in attached file