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

Get Ranking from Datawarehouse

Questions
Tags
Users
Badges
Fran Burgos
(123●1●23●52) Mar 07 '16, 5:04 a.m.
I have a backlog plan with a ranked list view (explicit ranking) and I wish build a report using the rank assigned to WIs into that plan. I have been looking for the rank in DW database but I didn't find any schema or table which contain the ranking values. ¿Where can I find this information?

0 votes

2 answers
5,530 views
0 votes

Accepted answer

Permanent link
Francesco Chiossi
(5.7k●1●11●19) Mar 07 '16, 5:10 a.m.
Hello Fran,

The information  about RTC plans is not stored in the data warehouse.
You can see the list of available elements,  their respective tables in the data warehouse and the data model elements in the Data Dictionary:

Data dictionary for change and configuration artifacts
http://www.ibm.com/support/knowledgecenter/SSYMRC_6.0.1/com.ibm.team.reports.doc/topics/ccm/ccm-roles.html?lang=en

If you think this feature would add business value to your usage of the product, I would suggest opening a Request for Enhancement (RFE) directly on the

IBM RFE Community
http://www.ibm.com/developerworks/rfe/

In this way it can be taken into consideration by development for inclusion in future releases.

Best Regards,

Francesco Chiossi

Fran Burgos selected this answer as the correct answer

0 votes

One other answer

Permanent link
Steven Shaw
FORUM MODERATOR / JAZZ DEVELOPER (551●1●3) edited
Mar 24 '16, 2:24 p.m.
Hello Fran,

As an aside it is possible to report on Rank in the JRS Report Builder 6.0.1.  When you are creating a story on Work Items, you can add Rank as a column that will be get displayed in the table.  Then you can sort on Rank in the Report results if desired.  However it's only possible to add Rank as a column, you can't add any condition on Rank.

Hope that helps,

-Steve

0 votes

Comments
Fran Burgos
Mar 28 '16, 10:50 a.m.
We use Cognos for reporting and we use the DW as data source. We have developed a JAVA program which connects to RTC API and reads information from plans, then it stores plans data and rank values in two new tables in DW.

Jamie Berry
Dec 14 '16, 12:06 p.m.
Steve,  I am looking at JRS Report Builder 6.0.3 and do not see an option to add the Rank value as an attribute column in the report.  Can you be more specific on how this is accomplished? Thank you, Jamie.

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
× 485

Question asked: Mar 07 '16, 5:04 a.m.

Question was seen: 5,530 times

Last updated: Dec 14 '16, 12:06 p.m.

Confirmation Cancel Confirm