RQM Execution Trend report displays no data because the ITERATION_ID is always -1 in the Rational Insight data warehouse
- The RQM Execution Trend report has mandatory prompts "Test Plan" and "Test Milestone".
- The "Test Milestone" prompt values come from the Iteration values in the table RIODS.TESTPLAN_ITERATION_LOOKUP
- The "Test Milestone" prompt displays the iteration value for the test plan correctly.
- However, the table RIDW.F_EXECRESPOINTS_ITER_METRICS that is accessed to get the execution results has an ITERATION_ID value of -1 for all records.
- The ITERATION_ID for the RIDW.F_EXECRESPOINTS_ITER_METRICS table is obtained from the RIODS.EXECUTION_RESULT table, which also has an ITERATION_ID value of -1 for all records. It has a value of -1 for all records, because there is no lookup on the Iteration.
- Selecting the correct "Test Milestone" results in no data displayed in the report, because the correct "Test Milestone" does not exist in the RIDW.F_EXECRESPOINTS_ITER_METRICS table.
- We recently switched from a standalone data warehouse populated by the Java ETL to a shared Rational Insight data warehouse. The Execution Trend report worked correct against the standalone data warehouse.
- Looking at the standalone data warehouse, the RIODS.EXECUTION_RESULT table has a valid ITERATION_ID (not a value of -1 for all records), which means that the RIDW.F_EXECRESPOINTS_ITER_METRICS table also has a valid ITERATION_ID.
- It appears that the Java ETL populates the ITERATION_ID correctly in the RIODS.EXECUTION_RESULT table, but the Rational Insight Data Manager ETL does not.
- Please verify that my understanding is correct.
- Is there a way to fix this in the Rational Insight DM ETL?