Get Ranking from Datawarehouse
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?
Accepted answer
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
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
One other answer
Hello Fran,
Hope that helps,
-Steve
Comments
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.
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.