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.

     

KNP's avatar
KNP
Super User
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.