CAST Engineering Dashboard - Violations - Critical Violations - Inconsistent value - values in Flex Report view and Project Data and Improvement does not match

Dashboard - FRAME_PORTAL_AUTO_REPORT_VIEW vs FRAME_PORTA_PRJECT_VIEW (Critical violations)

We found there are some critical violations (for instance 5) reflecting in Project Data & Improvement view and these are correct as verified in Investigation view.

However in Flex Report view, its showing only 3 critical violations after selecting any value for all the filters except Critical Contribution parameter.

1. Check that missing quality rules (for instance "Avoid cyclical calls and inheritances between packages" (#7292) and "Avoid classes overriding only equals() or only hashCode()" (#7434)) do not appear in Flex Report because the are violated only by objects with no Cost Complexity.
   Here is the query that returns violating objects with no cost metrics :

   select dos.OBJECT_ID, dos.OBJECT_NAME, dos.OBJECT_FULL_NAME, dos.OBJECT_TYPE_ID, ds.SNAPSHOT_NAME, dmt.METRIC_NAME
     from DSS_OBJECTS dos
     join DSS_OBJECT_INFO doi
       on doi.OBJECT_ID = dos.OBJECT_ID
      and dos.OBJECT_TYPE_ID not in (-100,-101,-102,20000) 
     join DSS_OBJECT_TYPES dot
       on dos.OBJECT_TYPE_ID = dot.OBJECT_TYPE_ID  
      and dot.OBJECT_GROUP = 0
     join DSS_METRIC_RESULTS dmr
       on dmr.OBJECT_ID = doi.OBJECT_ID
      and dmr.SNAPSHOT_ID = doi.SNAPSHOT_ID
      and dmr.METRIC_VALUE_INDEX = 1
     join DSS_SNAPSHOTS ds
       on ds.SNAPSHOT_ID = doi.SNAPSHOT_ID
     join DSS_METRIC_TYPES dmt
       on dmt.METRIC_ID = dmr.METRIC_ID + 1
       and dmt.METRIC_GROUP = 1
   where not exists (select 1 
               from DSS_METRIC_RESULTS dmrn 
              where dmrn.METRIC_ID = 65005
              and dmrn.OBJECT_ID = dos.OBJECT_ID
              and dmrn.SNAPSHOT_ID = doi.SNAPSHOT_ID 
               )            
   
   

   Note

   In case of PeopleSoft analysis, there will be no data available in the flex report because cost complexity is not calculated for PeopleSoft objects.