Using HP Application Lifecycle Management v11 to track testing, defects, etc. Within this web app they have analysis features that let you create graphs/reports for defects/tests/test instances. Does anyone know if you are able to create analysis reports for the steps within a test? For example, I want to be able to see how many steps for a test have been executed, passed, failed, etc. This could be for one test or done for a range of them.
Yes, it is possible to do this. Within the Analysis View, go to "New Excel Report". Excel reports are the most flexible feature of the Analysis View, because they allow you to write SQL queries against the ALM database to extract any detail you want, at any level of summary. You can then use Microsoft Excel itself to generate charts (if you desire) or pivot tables or pivot charts to further analyze and view the data in different levels of aggregation. Or, you can use your spreadsheet as input to a dedicated reporting tool such as Crystal Reports.
If you know absolutely nothing about SQL, you might try to take some tutorials on it at W3Schools -- once you're familiar with the basics, you can write queries against the QC/ALM database by learning the ALM database schema. Go to Help ->
As far as actual test steps, they are no different than any other object in ALM. The
See the little yellow key next to the "ID" columns (such as
If you also happen to know (or are willing to learn) Microsoft Visual Basic for Applications (VBA), you can do even more with ALM Excel Reports: the reports will automatically run a VBA macro for you when the report is generated, to automatically format, clean up, or arbitrarily process the data the report produces. This is to help you automatically prepare a report for management or your peers, even if your SQL query by itself can't produce a spreadsheet that's ready-to-go without modification. For example, you can generate Pivot Tables or Pivot Charts from VBA.
|show 2 more comments|