3 Replies Latest reply on May 25, 2020 7:55 AM by Dharmendra Reddy Nara

    Why is my profile warehouse only showing the most recent scorecard run?

    Bill Sanderson Active Member

      My scorecard has executed three times in the past 24 hours.  However, When I execute the following query I only see the most recent one:

       

      Select

      *

      From  Dqsinfa_Pwh.Idpv_Score_Smry

      Where 1=1

      And Scorecard_Name Like 'Hong_Kong_OMS_EBS_Order_Reconciliation_Scorecard%'

      Order By Time_Created Desc

      ;

       

      Hong_Kong_OMS_EBS_Order_Reconciliation_Scorecard Order_Header_Mismatches 42555 2 99.99 100 Overall_Reconciliation_Scores 89.66 28-FEB-20 05.00.20.000000000 AM

      Hong_Kong_OMS_EBS_Order_Reconciliation_Scorecard Order_Header_Orphans 42555 0 100 100 Overall_Reconciliation_Scores 89.66 28-FEB-20 05.00.20.000000000 AM

       

      Why don't I see the previous executions?

       

      Bill