Hi Robert,

I'm running 5.0.1 and only see 5 items in this report (minus the duplicate shown in your attachment).  Which version of JRS are you running, and which ETL's are you using?  I can check my 5.0 environment if that's the version you're using.

This is the SQL generated from the report where I also get the same 5 results.  Perhaps you can try running it against your data warehouse to see what you end up with?

SELECT DISTINCT CONCAT(CONCAT(r.REFERENCE_ID, ': '), r.NAME) AS request_title,
  r.URL AS request,
  CASE WHEN r.STORY_POINTS > 0 THEN CONCAT(CAST(r.STORY_POINTS AS VARCHAR(255)), ' pt')
       WHEN r.PLANNED_WORK > 0 THEN CONCAT(CAST(ROUND(r.PLANNED_WORK/3600, 2) AS VARCHAR(255)), ' h')
       ELSE '' END as request_size_unit,
  CASE WHEN r.STORY_POINTS > 0 THEN r.STORY_POINTS
       WHEN r.PLANNED_WORK > 0 THEN ROUND(r.PLANNED_WORK/3600, 2)
       ELSE 0 END as request_size,
  r.REQUEST_TYPE as request_type,
  i.TIMELINE_ID as timeline_id,
  i.TIMELINE_NAME as timeline,
  CASE WHEN pr.ITERATION_NAME = 'Info not available' THEN '' ELSE pr.ITERATION_NAME END AS old_iteration,
  r.ITERATION_NAME AS new_iteration,
  r.CREATION_DATE AS creation_date
FROM  RICALM.VW_RQST_HISTORY r
JOIN RICALM.VW_RQST_HISTORY pr ON r.PREV_REQUEST_HISTORY_ID = pr.REQUEST_HISTORY_ID
JOIN RIDW.VW_ITERATION i ON r.ITERATION_ID = i.ITERATION_ID
WHERE (r.ITERATION_ID <> pr.ITERATION_ID)
    AND i.START_DATE < CURRENT_TIMESTAMP
    AND i.END_DATE > CURRENT_TIMESTAMP
    AND r.REC_DATETIME > i.START_DATE
    AND r.REC_DATETIME < i.END_DATE
    AND r.ISSOFTDELETED = 0
    AND r.REQUEST_STATUS != 'Closed'
ORDER BY r.REQUEST_TYPE, request_size DESC, request_title