ODS imported from RQM have missing link between work items

Hi all,

Noted from using the default ETL for RQM 2.0, the constructed ODS has certain link information missing.

e.g. In "test case" table, the column "Test_Plan_ID" is always -1 regardless whether this test case has been associated with a test plan.

I am aware of the difference between RQM database and ODS database.
In RQM: test plan has a collection of test cases in test plan xml file.
In ODS: in test case table, each test case entry has a column "Test_Plan_ID".

May I know how to manipulate XML configuration and/or ETL to inherit the link between test plan and test case?

Is there anyone else trying to use RI for RQM reporting too?

Thanks.

Fu Yong