TCER count on Cognos report studio
hi dears,
I have prepared a test execution progress report in cognos report studio. Report is working fine but i have one issue.
in a test plan i am not able to identify how many test cases have execution records and how many have no execution records. I saw one field in test execution records TCER but i am not able to find this value in RDDI to see how many test cases of my test plan have execution records.
will really appreciate some one can please help me .
I have prepared a test execution progress report in cognos report studio. Report is working fine but i have one issue.
in a test plan i am not able to identify how many test cases have execution records and how many have no execution records. I saw one field in test execution records TCER but i am not able to find this value in RDDI to see how many test cases of my test plan have execution records.
will really appreciate some one can please help me .
Accepted answer
Hello Muhammad,
in the data model Test Cases are linked to the Test Plans they are part to through Test Case Related Test Plans and TCER are linked to Test Cases through Test Case Related Execution Work Items.
You can leverage both links in the same query.
For example you can build a query with the following elements:
Operational Data Store > Test Case Area > Test Case > Test Case ID
Operational Data Store > Test Case Area > Test Case > Reference ID
Operational Data Store > Test Case Area > Test Case > Name
Operational Data Store > Test Case Area > Test Case Related Execution Work Items > Execution Work Item ID
Operational Data Store > Test Case Area > Test Case Related Execution Work Items > Name
Operational Data Store > Test Case Area > Test Case Related Execution Work Items > Test Plan ID (EWI Test Plan ID)
Operational Data Store > Test Case Area > Test Case Related Execution Work Items > Test Plan Name
Operational Data Store > Test Case Area > Test Case Related Test Plans > Test Plan ID (TP Test Plan ID)
Operational Data Store > Test Case Area > Test Case Related Test Plans > Test Plan Name
Create a filter like the following:
([TP Test Plan ID]=[EWI Test Plan ID]) or ([EWI Test Plan ID] is null)
Optionally you can further filter for the specific test plan you are interested in.
This will make your query list all the test cases related to a test plan and the TCER linked to the test case for that specific test plan.
The rows with empty EWI Test Plan ID will highlight those test cases having no TCER for that specific test plan.
Below is a sample of the output:
We can see that the test cases with Reference ID 1, 6 and 12 has no TCER for the System Verification Test Plan.
From that base query you can calculate the necessary counts and summaries.
Best Regards,
Francesco Chiossi
in the data model Test Cases are linked to the Test Plans they are part to through Test Case Related Test Plans and TCER are linked to Test Cases through Test Case Related Execution Work Items.
You can leverage both links in the same query.
For example you can build a query with the following elements:
Operational Data Store > Test Case Area > Test Case > Test Case ID
Operational Data Store > Test Case Area > Test Case > Reference ID
Operational Data Store > Test Case Area > Test Case > Name
Operational Data Store > Test Case Area > Test Case Related Execution Work Items > Execution Work Item ID
Operational Data Store > Test Case Area > Test Case Related Execution Work Items > Name
Operational Data Store > Test Case Area > Test Case Related Execution Work Items > Test Plan ID (EWI Test Plan ID)
Operational Data Store > Test Case Area > Test Case Related Execution Work Items > Test Plan Name
Operational Data Store > Test Case Area > Test Case Related Test Plans > Test Plan ID (TP Test Plan ID)
Operational Data Store > Test Case Area > Test Case Related Test Plans > Test Plan Name
Create a filter like the following:
([TP Test Plan ID]=[EWI Test Plan ID]) or ([EWI Test Plan ID] is null)
Optionally you can further filter for the specific test plan you are interested in.
This will make your query list all the test cases related to a test plan and the TCER linked to the test case for that specific test plan.
The rows with empty EWI Test Plan ID will highlight those test cases having no TCER for that specific test plan.
Below is a sample of the output:
We can see that the test cases with Reference ID 1, 6 and 12 has no TCER for the System Verification Test Plan.
From that base query you can calculate the necessary counts and summaries.
Best Regards,
Francesco Chiossi