# How is is possible to create a Requirements Traceability Matrix with VP? **URL:** \ **Category:** How To\ **Tags:** bpmn, sysml, uml, modeling\ **Created:** [August 4, 2020, 1:15am UTC](https://forums.visual-paradigm.com/t/how-is-is-possible-to-create-a-requirements-traceability-matrix-with-vp/16241 "2020-08-04T01:15:12Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![cpo](https://forums.visual-paradigm.com/user_avatar/forums.visual-paradigm.com/cpo/32/4758_2.png) [@cpo](https://forums.visual-paradigm.com/u/cpo)\ **Post date:** [August 4, 2020, 1:15am UTC](https://forums.visual-paradigm.com/t/how-is-is-possible-to-create-a-requirements-traceability-matrix-with-vp/16241/1 "2020-08-04T01:15:12Z")
How is is possible to create a Requirements Traceability Matrix with VP? ---
**Author:** ![Jick](https://avatars.discourse-cdn.com/v2/letter/j/ea666f/32.png) [@Jick](https://forums.visual-paradigm.com/u/Jick)\ **Post date:** [August 4, 2020, 2:18am UTC](https://forums.visual-paradigm.com/t/how-is-is-possible-to-create-a-requirements-traceability-matrix-with-vp/16241/2 "2020-08-04T02:18:31Z")
> [@cpo](#): > > Requirements Traceability Matrix 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 > **[On-Demand Model ETL - Next-Generation Modeling Utility](https://www.visual-paradigm.com/features/on-demand-model-etl/)** > > Learn how to enrich your visual model with smart On-Demand Model ETL feature - Extract, Transform and Load model elements Knowhow - Query Model Element’s Relationships using ETL Table: > **[Query Model Element’s Relationships using ETL Table - Visual Paradigm Know-how](https://knowhow.visual-paradigm.com/diagramming/etl-nested-query/)** > > On-Demand Model ETL (Extract, Transform & Load) is a facility which allow user to query on their model elements (extract), manipulate them (transform) and further visualize them in diagram (load). The ETL table not just allow you to perform query... Video: What is On-Demand Model ETL > **[Video Guide: What is On-Demand Model ETL](https://circle.visual-paradigm.com/what-is-on-demand-model-etl/)** > > Design your desirable views of model data in a tabular form for bulk-view/edit/prioritize/visualize using Model ETL big data technology. Best regards, Jick Yeung ---
**Author:** ![BGeorge](https://avatars.discourse-cdn.com/v2/letter/b/a5b964/32.png) [@BGeorge](https://forums.visual-paradigm.com/u/BGeorge)\ **Post date:** [April 9, 2021, 4:25pm UTC](https://forums.visual-paradigm.com/t/how-is-is-possible-to-create-a-requirements-traceability-matrix-with-vp/16241/3 "2021-04-09T16:25:11Z")
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](https://forums.visual-paradigm.com/uploads/default/original/2X/8/8c4eac78ae863011a217436769e16029b92e745f.png) 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 ---
**Author:** ![Jick](https://avatars.discourse-cdn.com/v2/letter/j/ea666f/32.png) [@Jick](https://forums.visual-paradigm.com/u/Jick)\ **Post date:** [April 12, 2021, 2:48am UTC](https://forums.visual-paradigm.com/t/how-is-is-possible-to-create-a-requirements-traceability-matrix-with-vp/16241/4 "2021-04-12T02:48:17Z")
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 ---
**Author:** ![BGeorge](https://avatars.discourse-cdn.com/v2/letter/b/a5b964/32.png) [@BGeorge](https://forums.visual-paradigm.com/u/BGeorge)\ **Post date:** [April 12, 2021, 1:53pm UTC](https://forums.visual-paradigm.com/t/how-is-is-possible-to-create-a-requirements-traceability-matrix-with-vp/16241/5 "2021-04-12T13:53:29Z")
Hi Jick, Attaching a sample project. [Test.vpp](https://forums.visual-paradigm.com/uploads/short-url/oPSbfNA70eGZGYxGTbrW2075p28.vpp) (761 KB) This is what I would expect the ETL table to look like. ![image](https://forums.visual-paradigm.com/uploads/default/original/2X/c/c58fe3cfbd139303dd2d6d4e4d6199bb607f05f3.png) Thanks in advance, Bibin ---
**Author:** ![Jick](https://avatars.discourse-cdn.com/v2/letter/j/ea666f/32.png) [@Jick](https://forums.visual-paradigm.com/u/Jick)\ **Post date:** [April 13, 2021, 1:06am UTC](https://forums.visual-paradigm.com/t/how-is-is-possible-to-create-a-requirements-traceability-matrix-with-vp/16241/6 "2021-04-13T01:06:22Z")
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 ---
**Author:** ![Jick](https://avatars.discourse-cdn.com/v2/letter/j/ea666f/32.png) [@Jick](https://forums.visual-paradigm.com/u/Jick)\ **Post date:** [April 13, 2021, 6:33am UTC](https://forums.visual-paradigm.com/t/how-is-is-possible-to-create-a-requirements-traceability-matrix-with-vp/16241/7 "2021-04-13T06:33:51Z")
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](https://forums.visual-paradigm.com/uploads/default/original/2X/e/edc2a9d6f57e5ec9108e7742e8922a26ef77924c.png) 2. Configure Columns. Select ID, as shown in the image below. 3. Click **OK**. 4. Press the **Ctrl** key and click on the **Configure Columns** button to open the advanced configuration window. ![image](https://forums.visual-paradigm.com/uploads/default/original/2X/a/adf2badda44c02d956d20718f6f95e94ba42bdbe.png) 5. Click Add Column at the top right of the window. 6. Click on the combo box of the newly created column, and then select Relationship \> Anchor (Relationship) from the drop-down menu. 7. Click on the tiny button with tooltip Element References criteria… as shown below. 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](https://forums.visual-paradigm.com/uploads/default/original/2X/2/27c5e7183ef1408f7215014981a6c4ce79d0ec70.png) 9. Click OK to confirm. 10. Click on the Select sub-level button. 11. Click on the combo box and select Relationship \> RequirementDerive (Relationship) from the drop-down menu. 12 Again, add a sub-level. ![image](https://forums.visual-paradigm.com/uploads/default/original/2X/2/296406531d11bff9b9bfc64227482880eb0fd9ea.png) 1. This time, select **user ID**. ![image](https://forums.visual-paradigm.com/uploads/default/original/2X/3/3399e2bcef5f6d80361896f80e562f160bcc2c30.png) By clicking OK to confirm the change, you will obtain the table below: ![image](https://forums.visual-paradigm.com/uploads/default/original/2X/3/33c031f3568077d504d8922d721aaf19705411b7.png) 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](https://forums.visual-paradigm.com/uploads/default/original/2X/1/1514ea49dc2e87a404802dbc314e6d7a2e3f5ae4.png) 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](https://forums.visual-paradigm.com/uploads/default/original/2X/3/30663d27e47b3dd6ad5320ee71d471abed8e8c82.png) 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](https://forums.visual-paradigm.com/uploads/default/original/2X/6/63a2933ea704b9ae340cb8aed030cab9daa323b3.png) Now, go back to the configuration screen of the ETL Table. Click on in the third item of the 4th column. ![image](https://forums.visual-paradigm.com/uploads/default/original/2X/2/226a266bdb6f2b3c4173770e1c304b7791fedc58.png) Filter by Requirement. Add a condition: stereotypes = SystemSpec. See the image below for details. ![image](https://forums.visual-paradigm.com/uploads/default/original/2X/b/b20c0f0a2e542d2ec0bca0302bab580e11f424ad.png) This is the final result: ![image](https://forums.visual-paradigm.com/uploads/default/original/2X/8/873004451c82fa465045028d05e469d4302c39ed.png) Hope this helps. Feel free to let me know if you cannot follow. Best regards, Jick Yeung ---
**Author:** ![BGeorge](https://avatars.discourse-cdn.com/v2/letter/b/a5b964/32.png) [@BGeorge](https://forums.visual-paradigm.com/u/BGeorge)\ **Post date:** [April 13, 2021, 11:43am UTC](https://forums.visual-paradigm.com/t/how-is-is-possible-to-create-a-requirements-traceability-matrix-with-vp/16241/8 "2021-04-13T11:43:17Z")
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 ---
**Author:** ![Jick](https://avatars.discourse-cdn.com/v2/letter/j/ea666f/32.png) [@Jick](https://forums.visual-paradigm.com/u/Jick)\ **Post date:** [April 14, 2021, 12:49am UTC](https://forums.visual-paradigm.com/t/how-is-is-possible-to-create-a-requirements-traceability-matrix-with-vp/16241/9 "2021-04-14T00:49:57Z")
Hi Bibin, You are welcome. Please feel free to contact us again if you have any questions about ETL or other features. 🙂 Best regards, Jick Yeung