fbpx
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

6 Secrets To A Successful Atlassian Migration At Scale

6 Secrets To A Successful Atlassian Migration At Scale

With large scale migrations, large user bases, multiple Atlassian tools, plenty of apps, and lots of data, moving to Atlassian Cloud may feel like a steep mountain to climb. But, it doesn't have to be. In fact, we've already helped many customers make the move. Plus,...

Related Resources

Storytelling with Data

Storytelling with Data

Telling a story and telling a story with data are similar, but also different. And many of the differences are points that people don’t consider.  In this blog, we’ll try to break down the components of storytelling with data in an effort to share main points to...

Data Engineering Supports Digital Transformation

Data Engineering Supports Digital Transformation

Data engineering supports digital transformation. Fact. But, how do companies move away from more paper processes and towards digital transformation? It’s not easy. And, the larger the organization, the more difficult it is. Companies can take solace in knowing there...

Latest News From PTC From Q3 2022

Latest News From PTC From Q3 2022

PTC have been leaders for the past 30 years. They’ve led the charge in helping manufacturers solve key business challenges to achieve their goals with digital solutions in real-world applications. PTC has a wide variety of products like ThingWorx, Creo, Onshape,...