It's all about the answers!

Ask a question

Capacity Utilization - Reporting on User Role

Alick Banda (43113) | asked Sep 01 '17, 4:44 a.m.

 Good day,

We are currently using the IBM CLM 6.0.0 solution, and would like to find out how to generate a report that shows/groups users with a specific role (e.g Team Member), within a Project Areas/Team Areas.

The members of the project/team area have their work environment configured to about 8 hours (depending on role), and the idea is to compute/ compare planned time (on task level), vs their allocated time (based on the work environment), and also to possibly show how much free time a team/project member could possibly have.

Thank you.


One answer

permanent link
Ralph Schoon (57.1k23642) | answered Sep 01 '17, 7:59 a.m.

I wonder why you are not using the built in feature - granted, it is role agnostic -

Alick Banda commented Sep 04 '17, 10:15 a.m. | edited Sep 04 '17, 1:20 p.m.

 Hi Ralph,

Thank you very much for your response.

I have gone through the articles that you sent, but unfortunately, does not quite meet the use case as required by our development leads (and teams) .

Our development teams/CFTs (cross functional teams) are made up of various individuals with different roles (dev, qc, architect etc). Each function (e.g. dev) represented in the CFT is managed by different function/line managers (in this case dev manager),  who manages various developers, and allocates/seconds them to various CFTs. Each function/line manager basically wants to understand:
  1. The total amount of time spent across CFTs by the function  ( e.g. developers) .
  2. The amount of time available (or not used)  by the function given the Work Environment configured in CCM/RTC.
  3.  Who (a possible drill down) in the function is under allocated, or over allocated.

Kindly note that the roles defined in our jazz environment basically represents the function to which a team member belongs/is responsible for.

I hope the above gives some context and clarity in this regard.

Thank you,


Ulf Arne Bister commented Sep 04 '17, 10:45 a.m.


we have seen similar requests by some customers. One way of coming up with this cross team / role based reporting is to write your own custom BIRT report.
To used BIRT in RTC 6.x you still need the 2.6.2 version of BIRT Designer (a bit hard to come by) and create a report design with Jazz data source (e.g. Data Warehouse) and a lot of javascript evaluation and computation.
Some skills are needed but once you deploy the .rpt to RTC you can use / reuse the report at leisure.

Your answer

Register or to post your answer.