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

Hi koorosh,

 

It seems to work for me. See attached.

Can you provide more detail about the problem you are having?

 

    • 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