Forum Discussion

YeonseokKim's avatar
YeonseokKim
Frequent Visitor
3 years ago

How can I make Date hierarchy?

I want to make date hierarchy. But, There is no date hierarchy for some column which date type is date. 

Could you give me any advise to make Date hierarchy?

 

*Date hierarchy 

 

 

 

*No-Date hierarchy 

 

Need Help

3 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Icon for Super User rankSuper User
    3 years ago

    Hi,

    I am not sure if I understood your question correctly, but please check File -> Options and then the below.

    Please try to select the Time Intelligene -> Auto date/time option. 

    And then, if it still does not work, try to go to the Dim Calendar Table, and "Unmark as date table".

     

     

     

     

    These operations will make all date datatype columns to work as a date column separately.

     

    I hope this helps.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      It worked.....Thanks for sharing....my problem is solved

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Create the columns that you require for your Date Hierarchy (Year, Quarter, Month, etc.) and then simply make a new Hierarchy using the Year Column. Once you have done that, add the other columns in that newly created hierarchy. 

     

    This video might help you out: https://www.youtube.com/watch?v=xnWZrIV_g9s