Forum Discussion

K2_Gail's avatar
K2_Gail
Regular Visitor
9 years ago

Date Hierarchy for multiple datetime columns - inconsistent behavior

I have data coming from SQL. The table in SQL has multiple columns of type "datetime". I imported the data (it is not Direct Query). I have created a Date table, and defined relationships. I believe...
K2_Gail's avatar
K2_Gail
Regular Visitor
9 years ago

So, I'm still not sure I understand WHY this works, but I removed ALL relationships between date/time columns in my data table and my Calendar/Date table. Then, all my date/time columns display proper Date Hierarchies.

 

I'm still pretty new to all this, so I'm not sure why I need to REMOVE the relationships, but that seems to have given me the results I wanted, at least.

 

v-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
9 years ago

K2_Gail

 

What is the relationship between your data table and Calendar (Date) table, one to many or one to one?

 

Best Regards,

Herbert

  • K2_Gail's avatar
    K2_Gail
    Regular Visitor
    9 years ago

    Well, initially, I was setting it up one-to-many. And when that was not working so well, I tried one-to-one.

    Then, I removed them entirely, and things worked the way I wanted. :)

    • v-haibl-msft's avatar
      v-haibl-msft
      Microsoft Employee
      9 years ago

      K2_Gail

       

      I just tried with two simple tables, one Calendar table and one Sales table. They have one to many relationship with Date key as below.

       

      The Date Hierarchy works well in following column chart. Is there any difference between us?

       

      Best Regards,

      Herbert