3 Replies Latest reply: Feb 5, 2015 9:30 AM by Gysbert Wassenaar RSS

    Hierarchy and Slowly Changing Dimensions

      Hi,

       

      I have a problem with organization hierarchy.

      Organization table is joined to link table with interval match (this link is working OK)

       

      problem.png

       

      main problem is that in d_organization table I have multiple rows with same ID

      Organization_id
      Namescd_start_datescd_end_date
      1001Name 101.01.201210.12.2012
      1001Name 111.12.201231.12.2014
      1001Name 201.01.201531.12.9999

       

      How can I create Hierarchy with hierarchy()-funktion so that it's working properly with slowly changing dimensios?

      At the moment Name 1 and Name 2 are both always active

       

      cheers,

      Tommi