2 Replies Latest reply on Jun 27, 2018 9:31 AM by Thomas Whitfield

    Data source: join a fact table, that has multiple date attributes (shipped date, order date, etc) and I have a single date dimension table. Do I need to create a date dimension table for each fact table date attribute?

    Thomas Whitfield

      First time posting, so sorry if I break any protocols.

       

      Title says it all I believe. My fact table has multiple date attributes (shipped date, order date, etc) and I have a single date dimension. When I do any time of join on the dimDate to Fact.Shipped_date, everything renders fine on sheet. But when I add the Order date attribute to dimDate join, I do not receive any results.

       

      So, I am trying to confirm if I need a seperate dimDate table for each fact date column?

       

      Thank you.