2 Replies Latest reply on Oct 29, 2015 4:32 AM by kettan

    Tableau report out of SCD type 2 table

    Satheesh B

      Hello All,

       

      I want to build a report out of SCD type 2 table in Tableau. Below is my scenario.

       

      My SCD type 2 table has effective start and end date in it. I need to prepare a report from this table based on the reporting day. By default, report has to be built with recent snapshot of the table. If my reporting date is yesterday, report has to show only the changes until yesterday. Similarly, whatever the date is passed, data changes until that date needs to be considered for the report.

       

      Is there any possible way to implement this? If so, can you please provide more info on the approach.

       

      Thanks in advance!

       

      Regards,

      Satheesh B