9 Replies Latest reply: Oct 22, 2013 4:16 AM by Said Farid RSS

    How to do as of report for SCD?

      Hi,

       

      I already have the SDC or slowly changing dimension application, but my problem is, how can I show reports depending on selected date,

       

      These are the data:

       

      NameNoNameStatusMostRecentValidFromValidTill
      10001BillMarried110/5/201210/5/2012
      10001BillSingle010/3/201210/4/2012
      10002ReaMarried110/5/201210/5/2012
      10002ReaSingle010/3/201210/4/2012
      10003LudySingle110/3/201210/5/2012
      10004KhenIn Relationship110/5/201210/5/2012
      10004KhenSingle010/3/201210/4/2012
      10005LhaiIn Relationship110/5/201210/5/2012
      10005LhaiSingle010/3/201210/4/2012
      10006PyeIn Relationship110/5/201210/5/2012
      10006PyeSingle010/3/201210/4/2012
      10007MarkSingle110/5/201210/5/2012
      10008BambooSingle110/5/201210/5/2012
      10009JhingSingle110/5/201210/5/2012
      10010ElizaIn Relationship110/5/201210/5/2012
      10011KirkIn Relationship110/5/201210/5/2012
      10012CharmIn Relationship110/5/201210/5/2012

       

      I just don't know how can I show the status if I want to see employee status as of

       

      1. Oct 3, 2012

      2. Oct 4, 2012

      3. Oct 5, 2012

       

      Will you help me how to show the as of reports?

       

      Thanks,

      Bill