How can I make Date hierarchy?

[YeonseokKim]

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 

[HassanAshas]

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

[Jihwan_Kim]

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.

[Poojitha_Meda]

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