BIRT report showing all streams which use a particular component
How can we create a BIRT report showing all streams which use a particular component?
You can find all relationships between streams and components, or between workspaces and components, using these command lines:
scm list streams -r <repository context> -u <username> -P <password> --verbose --json
or
scm list workspaces -r <repository context> -u <username> -P <password> --verbose --json
Can the same relationships show as a BIRT report? Perusing the data dictionary, and experimenting with BIRT data sets, I only see streams and components in separate views and no information encoding the relationships between the two.
You can find all relationships between streams and components, or between workspaces and components, using these command lines:
scm list streams -r <repository context> -u <username> -P <password> --verbose --json
or
scm list workspaces -r <repository context> -u <username> -P <password> --verbose --json
Can the same relationships show as a BIRT report? Perusing the data dictionary, and experimenting with BIRT data sets, I only see streams and components in separate views and no information encoding the relationships between the two.
One answer
Data source:
SCM_SNAPSHOT
Table name:
TOTALS
Columns:
PROJECT_AREA_NAME
STREAM_NAME
COMPONENT_NAME
Comments
This requires that you enable snapshots for each of your streams:
https://<SERVER>/<ROOT>/web/projects/<PROJECT>#action=com.ibm.team.reports.admin&id=com.ibm.team.reports.admin.datawarehouse.scm
See also: https://jazz.net/help-dev/clm/topic/com.ibm.team.reports.doc/topics/r_ccm_sc_reports.html
(Note: The steps given in the help link above, require that you have deployed the default reports. If you have not done that, you can create a Scrum project on the same server, access the reports from there, and enable data collection for streams from within those reports.)