topic Re: HP ALM/QC dashborad in QlikView

HP ALM/QC dashborad

Anonymous — Mon, 23 Feb 2015 13:04:36 GMT

Hi All,

Do any body created test management dashboard using HP ALM/QC as source with all tables like , Test, defect, requirement etc.

Could you please share the data model for the same.

what are the relationship between test cases, test ID , defect id and req ID .

Any help will be appreciated.

Thanks in advance

BKC

Anonymous — Mon, 23 Feb 2015 16:14:45 GMT

Can anybody plz reply .

shayraber — Thu, 19 Nov 2015 09:47:47 GMT

I have one for the HP QC but its confidential and I'm not allowed to take it out of the organization.

What I can give you is website with all tables and the connections between them

check this:

the main table that will interest you are:

where:

REL_ID=RCYC_PARENT_ID

RCYC_ID=RQC_CYCLE_ID

RQC_REQ_ID=RQ_REQ_ID=RC_REQ_ID

RC_ENTITY_ID(if RC_ENTITY_TYPE='TEST')=TS_TEST_ID

TS_TEST_ID=RN_TEST_ID

RN_RUN_ID=ST_RUN_ID

ST_TEST_ID=TS_TEST_ID

hope that helps you