Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Building reports with Jazz Reporting Service (CLM 6.0)

Questions
Tags
Users
Badges
Leire Torres
(36●7●21) Oct 20 '15, 12:00 p.m.
Hello,

I want to build reports across CLM (v6.0 iFix003) projects using Jazz Reporting Service (JRS) but I am facing problems. 

When I choose the 'Build' option in JRS, I can see 'Change and Configuration management' application data, but I am not able to access 'Quality Management' or 'Requirements Management' data (neither artifacts nor projects).

What could be the issue and what can I do?

Thanks in advance,
Leire.


1

0 votes

2 answers
7,167 views
0 votes

2 answers

Permanent link
Darren Coffin
JAZZ DEVELOPER (182●3) Oct 20 '15, 12:43 p.m.
Hi Leire,

What JRS data source are you using for your reports? 

1.If it is a data warehouse data source, please make sure that the DCC ETL jobs were successfully run after artifacts were created in CCM and RM, so that the data would be available in the data warehouse. (go to /dcc/web, run all of the DCC jobs again and check that they all passed)

2. If it is a LQE data source, please make sure that in LQE, the TRS feeds for CCM and RM exist and indexed successfully. (under the Data sources section in /lqe)

3. If you are still not seeing the expected data in JRS after that, try going into the Data Sources page in /rs, select your data source, and click on Refresh.

0 votes

Comments
Darren Coffin
JAZZ DEVELOPER Oct 20 '15, 12:44 p.m.
I meant QM and RM (as those are the apps you're having issues with) instead of CCM and RM...

Leire Torres
Oct 21 '15, 2:58 a.m.
Thanks for the answer Darren.  The JRS data source is a data warehouse source (in /rs Data Sources appears as Rational Data Warehouse located in //<host>:1527/conf/jts/derby/warehouseDB).  As you said, I run all data warehouse collection jobs (Data Collection Jobs section in /dcc) and all of them finished successfully. All of these jobs are created by default, aren't they? I mean, I don´t have to add or create new ones. Am I right? After that, I refresh the data source and try building a report again, but I am still not seeing the expected data (the project list is empty, the Test Script and Requirement expandable menu does not show any item...)

Darren Coffin
JAZZ DEVELOPER Oct 21 '15, 9:39 a.m.
Leire, You're right, you shouldn't need to create new DCC jobs. Maybe try checking the resource groups for QM and RM are properly set up in DCC.  Go to /dcc/web, click on Resource Group Configuration, expand the sections for Rational Quality Manager and Rational DOORS Next Generation, click on the Test Connection in the top right for each section.  Ensure that there is actually data in QM and RM as well (at least a project created in each), I think the options might not show up in JRS if DCC didn't have anything to populate the data warehouse with to begin with.

Leire Torres
Oct 21 '15, 11:58 a.m.
 The test connection is successfull in both (Successfully connected to the resource group) and I also have one project in each application... 

Darren Coffin
JAZZ DEVELOPER Oct 21 '15, 1:06 p.m.
Does your user have read access to the project areas in RM and QM?  You can try disabling project access control on the JRS data warehouse data source temporarily, to see if that fixes it.  (/rs, data sources, click on the DW data source, deselect the project access control checkbox, save.)

Leire Torres
Oct 22 '15, 3:24 a.m.
That option is already disabled... Anyway, I also checked the user read access in Lifecycle Projects Management area and all the users are members of the project and all of them have read access... As I didn´t know what was going on, I created a new lifecycle project, and in this case I can see all (QM, RM and CCM) projects in JRS projects list. I checked the projects configuration and I cannot see any difference... The only difference is that the first project (not the new one) has a global configuration project with baselines and streams. Could it be a problem? 

Leire Torres
Oct 22 '15, 7:00 a.m.
It seems I´ve partially solved the problem! I didn´t know that reporting on configurations requires Lifecycle Query Engine using Configurations as Data Source in JRS.  At this moment, I can see CCM and QM projects and info, but I can´t see RM project and something very strange happens with it: 1. If I select 'Requirement' artifact type without any traceability with other artifacts, such as test cases,  in the Limit scope section RM project does not appear, but the report runs correctly and I can see the requirements list. 2. If I select 'Requirement' artifact type with traceability with other artifacts, such as test cases, in the Limit scope section RM project does not appear, only RQM project. An so, when I execute the report the following warning message appears: The traceability report may be missing results because there are artifact types in the report that do not have any project area data.

showing 5 of 7 show 2 more comments
Permanent link
Taly Hotimsky
(271●46●57) Oct 20 '15, 2:17 p.m.
 To the best of my knowledge, you can only select one resource (CCM/RM/QM) as the starting point to your report on the current version.
Even though you can get relational data through links (ie. WI associated to Test Cases), you cannot select both WIs and TCs (for instance) as a starting point.

0 votes

Comments
Leire Torres
Oct 21 '15, 2:37 a.m.
Thanks for the answer Taly. I know that I can only select one resource as starting point. The problem is that if I select RM or QM  I don´t see any information (the project list is empty, the Test Script and Requirement expandable menu does not show any item...).

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 7,622
× 363

Question asked: Oct 20 '15, 12:00 p.m.

Question was seen: 7,167 times

Last updated: Oct 22 '15, 7:00 a.m.

Confirmation Cancel Confirm