Which information in the data warehouse can be used to get the Last Modified Date in an RQM project using BIRT?
I am using BIRT reports to extract the project area and the last modified date using the following schema:
Snapshot: LIVE_SNAPSHOT
Table Name: com.ibm.rqm.deployment.Project
Columns: projectArea.name & projectArea.modified
The last modified date is giving the date when any kind of change is done, which means even server side updates. I want to know when any test artifact was modified. Can anyone help me with the table name and column name for this?
Snapshot: LIVE_SNAPSHOT
Table Name: com.ibm.rqm.deployment.Project
Columns: projectArea.name & projectArea.modified
The last modified date is giving the date when any kind of change is done, which means even server side updates. I want to know when any test artifact was modified. Can anyone help me with the table name and column name for this?
Accepted answer
Hi Maria,
Unfortunately there is no support for custom RQM BIRT reports, so there is not much detail I can give you. Since you mentioned 'data warehouse' in the title, I assume you want to get your data from there. If that's the case, then instead of using the LIVE_SNAPSHOT, use the PLANNING_SNAPSHOT and look for the tables whose name starts with 'REMOTE'. For instance, if you want to see the last modified data of the test cases stored in the data warehouse, you would use the field TESTCASE_MODIFIED from the table REMOTE_TESTCASE_DIMENSION. I hope this helps.
Thank you,
Clara Forero
Unfortunately there is no support for custom RQM BIRT reports, so there is not much detail I can give you. Since you mentioned 'data warehouse' in the title, I assume you want to get your data from there. If that's the case, then instead of using the LIVE_SNAPSHOT, use the PLANNING_SNAPSHOT and look for the tables whose name starts with 'REMOTE'. For instance, if you want to see the last modified data of the test cases stored in the data warehouse, you would use the field TESTCASE_MODIFIED from the table REMOTE_TESTCASE_DIMENSION. I hope this helps.
Thank you,
Clara Forero
Comments
Clara, I have another question in addition to the above three. When I run the report in production, I am getting the following error. What can be done about this? Please help. I realize there are too many records in the table therefore, seeing this error. But is there a solution for this?
org.eclipse.datatools.connectivity.oda.OdaException: Maximum record count exceeded