Reporting in HP Quality Center / Application Lifecycle Management (QC/ALM) using Open Test Architecture (OTA)

Light Up Keyboard

Let’s face it: reporting in HP Quality Center / Application Lifecycle Management (QC/ALM) has come a long way over the years, especially with the advent of the easier to use Dashboard interface. Even with the Dashboard, the output is oftentimes large and it is difficult to get a summary view of the testing and defect results. The solution here is typically Excel reporting in which you can define your own SQL calls and then utilize Visual Basic for Applications (VBA) to format the results of the report.  But still, we always expect more and have resorted to building custom reports outside of QC/ALM. These reports tend to be Excel-based using SQL. The pitfalls of this approach will be discussed in a separate blog in our QC/ALM series, stay tuned.


Yes, Mercury/HP has always provided a standard way of retrieving information but because it involves some programming it has remained somewhat hidden and underutilized. The Open Test Architecture (OTA) provides a standard interface for retrieving data from QC/ALM. You no longer need to know table names and database schemas to generate reports. If you are wondering about the power of OTA, consider that much of QC was developed using it.

Olenick has used OTA to create customized reports for numerous clients. The reports show metrics that are commonly required by development and support teams to gauge quality and deployment readiness in a concise manner. The reports can be generated in both Excel and Word formats, they run fast enough to be produced in near real-time for those 8:00 AM status meetings, and they are easy to modify.


Here is a sample report showing testing status based on functionality and the percent complete:

QCALM Reporting


Below is a report showing Planned vs. Actual test execution based on a release and/or cycle:


Cumulative Test Execution Metrics


Want to learn how to maximize your reporting in QC/ALM? Start a conversation using the comments section below.

By John McKeown, Lead Senior Consultant – Olenick & Associates, Chicago

Related Content: Dashboards, Dashboards, Microsoft Office, Quality & Testing, Reporting Analysis