Viewing Reports

To view product data, you can use the sample SQL Server Reporting Services (SSRS) reports installed with ALM Data Warehouse or reports you create in a different third-party reporting tool.

The sample SSRS reports are available in the Sample_Reports directory in the Helix ALM Data Warehouse application directory. When you deploy the reports, make sure that you change the source and initial catalog information.

To create the same reports using a different third-party reporting tool, use the SQL queries in the Direct SQL Query directory in the Sample_Reports directory.

The following SSRS sample reports are available.

Report name	Contains
All Items Assigned to User	A list of all items assigned to the selected users based on the selected item types, workflow states, and Helix ALM projects. Includes the item number, item type, workflow state, project name, and summary.
All Projects for Users	A list of all the Helix ALM projects the selected users can access.
Automated Test Run by Test Case	A list of test cases and test runs, and test results for test cases linked to run results.
Changes by Fixed Date	A list of issues with source control file attachments marked as fixed in the specified date range. Includes the filename, issue number, summary, fixed date, file version, related test case number, and related test run number.
Count of Defects by State by Time Period	The number of issues in each state at the end of a day, week, or month. Includes the time period start date and the workflow states in the selected Helix ALM project.
Defect Detailed Event and Status List with Days Spent	The status of the selected Helix ALM issue and the number of days it remained in each workflow state during the specified date range.
Defect Distribution for Previous 6 Months	A line chart that displays the distribution of new, open, and closed issues for the past six months from a selected month and year based on the selected Helix ALM projects.
Defect Summary Days Held in a Date Range for a User in a Source and Project	The number of issues in the selected Helix ALM project assigned to the selected user during the specified date range. Includes the number of days each issue has been assigned.
Defects by User in a Date Range	The number of issues created by the selected users in the selected Helix ALM projects during the specified date range grouped by severity.
Defects Reported by Product and Version	A list of issues based on the selected Helix ALM projects, products, and versions found. Includes the issue number, product, current workflow state, summary, date found, version found, found by user, and description.
Executed Test Run Count by Date (All Projects)	A list of test runs completed by assigned users during the specified date range. Includes a bar chart. This report assumes that the Pass and Fail events in the default test runs workflow are used. If you use different Pass/Fail events, you need to modify the SQL query to include the additional events.
Forward Traceability Report	A list of requirements included in the selected requirement documents in the selected Helix ALM projects with link and source control file name information. Includes the project, requirement number, test case summary, test case links, test run links, issue links, status, item status, and issue summary, and source control file name, version, and fixed date.
Helix ALM Activity Report by Project	A list of the number of opened, fixed, failed verification, and reopened issues, the number of executed and failed test runs, and the percentage of failed issues and test runs across all projects during the specified date range.
Issues Found by Customer for All Projects	A list of all issues found by all customers in all Helix ALM projects during the specified date range. Includes the customer name, company, Helix ALM project name, issue number, workflow state, and description.
Latest Test Run Status for Test Case by Project	A list of the latest test run results for all test cases in the selected Helix ALM projects. Includes the project name, test case number, test run number, test case summary, and status of each test run.
License Server Usage	Line charts that display the number of floating and named licenses for each product available on the Helix ALM License Server for the specified date range. Includes a chart that displays the average licenses available by hour based on a 24-hour period.
Summary Defect Activity for User in a Date Range	The number of issues the selected user marked as fixed, failed verification, and passed verification during the specified date range grouped by Helix ALM project.
Summary SCM Activity for User in a Date Range	The number of Surround SCM changelists committed, and files added, checked in, and deleted by the selected users during the specified date range grouped by mainline branch.
Test Cases By User in Date Range	The number of test cases created by the selected users across all Helix ALM projects in a specified date range.
Test Defect Links	A list of issues in the Released to Testing workflow state that are linked to test cases and test runs. Includes the link type, created date, and issue summary.
Test Run Set Distribution	The total number of test runs and the total number and percentage complete of passed, failed, and completed test runs in the selected test run sets for the selected Helix ALM projects. Includes the total number of reported issues and open issues for each test run set. Includes a pie chart for each test run set that displays the distribution of passed, failed, and incomplete test runs.
Test Runs Completed by Platform	A bar chart of completed test runs for the selected test variants. Separate charts are displayed for each selected project and test run set.
Total Activity for Single User	A list of the events performed by the selected user across all Helix ALM projects and Surround SCM mainline branches during the specified date range. Includes the event date, project or mainline, area of action (e.g., file, issue), filename or Helix ALM item number, event description, and comments entered when the event was entered.