How is is possible to create a Requirements Traceability Matrix with VP?

How To
, , ,
1

How is is possible to create a Requirements Traceability Matrix with VP?

2

Hi cpo,

Thank you for your post. We do not support Requirements Traceability Matrix, but we have a feature called ETL Table, which allows user to form a table by showing the selected properties of model elements. You can create an ETL Table to show the property values of requirements. More details:

Feature: On-Demand Model ETL

Knowhow - Query Model Element’s Relationships using ETL Table:

Video: What is On-Demand Model ETL

Best regards,
Jick Yeung

3

Is it possible to create an ETL table that maps requirements for each row in the following way:
Marketing Feature (single) → Marketing reqs (one or more) → Product req (one or more) → system req (one or more).

I have a requirements diagram that contains
Marketing Feature as an elementGroup linked to Marketing Reqs via Anchor
Marketing Reqs linked to Prod req as derive
Prod req linked to system req as derive

I created an ETL table that looks like this

image
image301×508 7.88 KB

There are two issues with this:

  • I cannot get system req ids
  • I would like to show one row for the same feature number (F1)

Any suggestions? @Jick @ShelLuser

4

Hi BGeorge,

Thank you for your inquiry. To avoid ambiguity, could you prepare a sample project that contains the requirement diagram and element you mentioned? We can then create an ETL and send you back the project, meanwhile providing you with the steps to do it.

Best regards,
Jick Yeung

5

Hi Jick,
Attaching a sample project.
Test.vpp (761 KB)

This is what I would expect the ETL table to look like.
image

Thanks in advance,
Bibin

6

Hi Bibin,

Thank you for the sample project and ETL table. I have passed the files to our engineers to study and I believe that they will check it soon. I will keep you posted on any updates.

Best regards,
Jick Yeung

7

Hi Bibin,

Currently, ETL table can only support part of your need - Up to the third column. There is a trick to work around though and I will explain it in a minute. The steps below show you how to configure the ETL Table to make things work.

  1. Create an ETL Table that lists Element Group
    image

  2. Configure Columns. Select ID, as shown in the image below.

    image
    image1342×813 62.4 KB

  3. Click OK.

  4. Press the Ctrl key and click on the Configure Columns button to open the advanced configuration window.
    image

  5. Click Add Column at the top right of the window.

    image
    image790×422 9.66 KB

  6. Click on the combo box of the newly created column, and then select Relationship > Anchor (Relationship) from the drop-down menu.

    image
    image736×468 16.1 KB

  7. Click on the tiny button with tooltip Element References criteria… as shown below.

    image
    image790×422 7.62 KB

  8. There are three rows by default: Model, Use Case and Actor. Change to select Requirement in the first row. Remove the second and third row.
    image

  9. Click OK to confirm.

  10. Click on the Select sub-level button.

    image
    image790×422 7.84 KB

  11. Click on the combo box and select Relationship > RequirementDerive (Relationship) from the drop-down menu.

    image
    image747×640 25.8 KB

12 Again, add a sub-level.

image
image790×422 8.06 KB

  1. This time, select user ID.
    image
    image790×422 11.6 KB

By clicking OK to confirm the change, you will obtain the table below:

image

How about the 4th column? You need a trick to make it work… Let’s go back to the configuration screen. Add a new column following the settings below. Do remember to filter the Anchor and RequirementDerive by Requirement.

image
image790×473 23.9 KB

Click OK to return to the ETL Table. You will see that both the MRD Reference and System Spec are included in the cell. This is because ETL Table tries to get both the source and target of the relationship.

image

In order to make it work, here is a workaround. Go back to the diagram first. For each of the SystemSpec requirements, add a stereotype <> (any name would be fine).

image
image756×418 18.9 KB

Now, go back to the configuration screen of the ETL Table. Click on in the third item of the 4th column.

image
image790×473 17 KB

Filter by Requirement. Add a condition: stereotypes = SystemSpec. See the image below for details.

image
image790×473 14.4 KB

This is the final result:

image

Hope this helps. Feel free to let me know if you cannot follow.

Best regards,
Jick Yeung

8

Hi Jick,

Thank you very much for the detailed instructions. I was able to follow step-by-step and get to the final result successfully.

Best Regards,
Bibin

9

Hi Bibin,

You are welcome. Please feel free to contact us again if you have any questions about ETL or other features. :slight_smile:

Best regards,
Jick Yeung