Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

How is it possible to measure Test Case Results in execution context of Test Suites?

Requirement

  • Measure Test Case Results in execution context of Test Plans and Test Suites

Situation
  • Using same Test Cases in multiple Test Plans and Test Suites for different test runs, because reusing Test Cases

Possible ETM Traceability Path with RS Report Builder
  • Test Suite Execution Record --> Test Suite --> Test Case --> Test Case Execution Record --> Test Case Result
  • Jazz Report Traceability Path - TSER_TS_TC_TCER_TCR.png

Resulting Measure
  • With this Traceability Path we measure also Test Case Results executed in context of other Test Plans and Test Suites

Question
  • How is it possible to measure Test Case Results in execution context of Test Suites?

Hints
  • We have also experiences with creating Jazz Reports with advanced SQL based on DB2 DWH
    • Edit Query in RS Report Builder
  • We haven't found additional helpfully DB2 DWH link views and DB2 DWH entity columns to solve this challenge
    • e.g. DB2 View RIDW.VW_EXECWORKITEM_TSTSUTE_LOOKUP is empty in our Jazz DWH
  • To use following additional context info in different entities is not enough to solve this challenge
    • using Test Plan info in Test Suite Execution Record and Test Case Execution Record
    • using Iteration info in Test Suite Execution Record and Test Case Result

IBM Jazz ETM - Traceability pathes
Jazz ETM - Test Artefacts - Traceability Pathes

0 votes



5 answers

Permanent link

It looks like a Jazz DWH or DCC Jobs issue since a long time --> DB2 View RIDW.VW_EXECWORKITEM_TSTSUTE_LOOKUP is empty

0 votes


Permanent link

IBM Ticket Case: TS018728822 created for this issue.

0 votes

Comments

IBM Ticket Case: TS018786530 in progress for this


Permanent link

Data security is a major concern for businesses, especially those dealing with sensitive financial, healthcare, or personal information. Power BI consultants implement Row-Level Security (RLS), Object-Level Security (OLS), and role-based access controls to protect data. Compliance with GDPR, HIPAA, SOC, and ISO standards is ensured through data encryption, governance frameworks, and secure API connections. Without strong security measures, businesses risk data breaches, legal penalties, and reputational damage. Power BI consulting services help establish audit logs, permission-based access, and multi-factor authentication, ensuring a safe and compliant data environment for business intelligence operations.

0 votes


Permanent link

You can measure test case results in the execution context of test suites by using test management tools or automation frameworks that track execution status (Pass/Fail/Skip), execution time, and error logs. Most frameworks like JUnit, TestNG, or tools like Azure DevOps, TestRail, and Jira provide detailed reports at both test case and suite levels. These help you analyze the overall test coverage, stability, and identify flaky or failing tests efficiently. Find out technology related articles on The Software Post.

0 votes


Permanent link

Alfons,


I was looking at your query and I think the problem you're having is that you're getting multiple results in the contexts of multiple test plans.

Instead of starting the query from the TSER, make it either start from the Test Plan, or use the TSER -> Reports on Test Plan relationship so you can then filter the Test Plans you want to see. That seems to be the issue -- you're literally asking for EVERY TSER.

Kevin Murphy
IBM Champion

0 votes

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 12,102

Question asked: Mar 07, 4:30 a.m.

Question was seen: 1,879 times

Last updated: Aug 14, 1:32 p.m.

Confirmation Cancel Confirm