1-888-310-4540 (main) / 1-888-707-6150 (support) info@spkaa.com
Select Page

Metrics, Metrics, Metrics in PTC Integrity: Part 2

Published by SPK Blog Post
on February 2, 2015

In my previous entitled “Metrics, Metrics, Metrics in PTC Integrity: Part 1” I introduced the out of the box traceability metrics that come with PTC Integrity, and talked a little bit about how they work. In this article I will build on that by showing how you can leverage those metrics to build a simple report to demonstrate the traceability coverage in your active projects. The report we are going to build is a simple back trace report as follows:

SPK_ABC

This report performs the following activites:

  1. It performs a query on the database to retrieve all of the document items in the database.
  2. It groups those results by Item type.
  3. Then it provides totals for each group of documents. Above we can see 13 Design Specification documents, as well as totals for all of the various content metrics.

Next I will take you step by step through the process of building this report using the PTC Integrity Report wizard.  Perform the following steps to build this report:

  1. From the Report menu in your PTC Integrity, select “Create…”  If the Report menu or the “Create…” option does not exist, you may have to customize your ViewSet to make it visible.  The “Create Admin…” option should only be used if you are a member of the Administrator group, and you are looking to build a system supported report for use across your entire PTC Integrity instance. In this case I just want to build a report for myself, and maybe a friend.
  2. This will open the PTC Integrity Report Wizard.  The first thing you do when you are creating a new report is to select the type of report you want to produce.  These types are called Report Recipes.  In this case we select the “Basic – HTML, Column, One Grouping, Field Compute”
  3. After selecting the “Next >” button we fill in attributes like a Name for the Report, the query you want to base your report on. In this case we use the Admin provided query: “Documents In Active Projects,” and a simple description.  In this case the report we are creating is for our own use, so the “Is Admin Provided” check box we’ll leave alone. (This option is only active when you belong to the administrator group.)
  4. On the Next panel, you select the style that can be applied to the HTML report.  There are several basic styles available for your convenience.  In this case I selected ALM 2009 for both the screen display and when the report is printed out.
  5. In the next panel, you can select an image already stored on your server as a logo for your report.
  6. Next you can set up a title, a header and a footer that will be displayed on your report as follows:
  7. After that, we select the fields that we included in the report above.
  8. The group by option will group all results returned from the query by the values of the field specified in the Group By field. In our case we are going to group the results by the Type field.
    Since the query we specified will only be returning items of that are documents, the values for Type will be restricted to values such as “Design Specification”, “Requirements Specification” and “User Needs”.  That means that the report will be broken up such that all returned “Design Specifications” will be together, all “Requirement Specifications” will be together and all “User Needs” will be together.
  9. On the next panel, we have the option of performing computations on the columns of data within each grouping.
  10. For the first computation, we will simply count all of the “Document Short Titles”.  To do this we first select the line with Document Short Title, and then select the edit button. This will open the Edit Expression dialog, where we can name the expression, set up the computation, and set a display pattern for the resulting integer.
  11. For the next computation, we want to add up all of the integers in the All Content Count column.  In this case we will use the “sum()” function to add up all the values in the named field.
  12. Similarly we will use the sum function to create totals for each of the columns, “Meaningful Content Count,” “Content Back Trace Count” and “Content Without Back Traces Count.”
  13. Next comes the Sort By panel.  Since this report is grouping the major items together already, sorting is probably less important.  In this case I simply sorted the items by their IDs.
  14. The final panel is the Report Sharing panel.  Using the Choose Principals button you can elect to share your new report with specific individuals and/or groups through-out your organization.  You can even delegate to individuals permissions to make changes to the report. In this case I simply shared the report with myself alone.

This report was just one example of what you can do with the reporting that comes with PTC Integrity.  In this case, I believe the ability to report on what has been properly traced in PTC Integrity will go a long way in determining whether or not you are ready to deliver whatever product you are using PTC Integrity to deliver.

In my next blog article, I will describe how to build a chart with PTC Integrity as opposed to a report.

Next Steps:

Latest White Papers

Three Trends Are Transforming The Service Desk

Three Trends Are Transforming The Service Desk

Your IT service desk is about to change. Find out what's shaping the future. Three factors — enterprise service management (ESM), collaboration, and intelligent service management — are driving the transformation of the service desk. To better meet customers’ needs...

Related Resources

Is The IT Department Really “Dead?”

Is The IT Department Really “Dead?”

“It’s Time to Get Rid of the IT Department.”  That was the title of an opinion piece recently published in the Wall Street Journal.  Provocative?  Sure.  My answer to this is not “yes,” but many of the author’s points are valid.  The Same Old IT Department? No, the IT...

How To Add More Disk Space To Your Redhat Server Without Reformatting

How To Add More Disk Space To Your Redhat Server Without Reformatting

(Originally published in 2012, updated January 2022.) One of the common tasks for any system administrator is managing disk space on a server. A common question is how to increase disk space on a linux system. I won't go into a boring lecture on why managing disk...

January 2022 vCAD feature updates

January 2022 vCAD feature updates

Happy New Year vCAD Users! It was a busy 2021 in terms of vCAD development and feature enhancements. We've been receiving lots of feedback regarding the platform, and we're assembling a roadmap for 2022 based on our users' needs. Here's what to expect in 2022:...