Forum Discussion

koorosh's avatar
koorosh
Post Partisan
4 years ago
Solved

Date Hierarchy

Hi Experts,  Why I can't create date hierarchy in the following date table ?   https://drive.google.com/file/d/18Vu30OqxLGZzbcJ9K37ME4yBbvpzGq7t/view?usp=sharing    
Need Help
  • KNP's avatar
    KNP
    4 years ago

    I understand the confusion now. You would think you would be able to do it like that. 

    See below video. Also, if you need to reorder the items in the hierarchy, it can be done from the model tab.

     

    I hope this helps.

     

koorosh's avatar
koorosh
Post Partisan
4 years ago

Thanks KNP,
A question, please. The summarization for each column of DimDate table (Year, Month, Quarter, Day)  should be "sum" or "Don't summarize".

 

Regards

KNP's avatar
KNP
Super User
4 years ago

Set to 'Don't Summarize', otherwise, if you were to drop Year into a table for example, it would try and sum up all the years instead of using it as an attribute.