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

Report showing all users and what percentage of their resource has been allocated to what projects.

Questions
Tags
Users
Badges
Lawrence .
(59●5●12) May 04 '17, 8:11 a.m.

Hi,

One of our customers wants to be able to do a report showing all users and what  percentage of their resource has been allocated to what projects.

For this, they need to know how to extract the resource allocation for each resource from the database.   
Do we have the information on table and columns where this data is stored in the RTC v6.0 datamodel.

I have already send the details on  Live_Contributor_Assignment and Live_Contributor_Working_Time
tables that are are described here:

Data Warehouse Snapshot Schemas                                       
https://jazz.net/wiki/bin/view/Main/DataWarehouseSnapshotSchemas20

I am not sure if this is all we have available.

Thanks very much

0 votes

1 answer
1,892 views
0 votes

One answer

Permanent link
Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER (64.0k●3●36●48) May 11 '17, 4:18 a.m.

First of all, it is discouraged to access the RTC Database directly. You should use the API, if available for that.


As far as I know, User Assignment Information is not stored in the data warehouse either. 

I was able to find several similar questions here: https://www.google.com/search?q=user+assignment+API+site%3Ajazz.net 


There is an internal Java API. Here some snippets I have figured out. Unfortunately I never managed to blog about it.

final IResourcePlanningClient resourcePlanning = (IResourcePlanningClient) teamRepository.getClientLibrary(IResourcePlanningClient.class);

private ItemCollection<IWorkResourceDetails> getWorkDetails(
IProgressMonitor monitor) throws TeamRepositoryException {
final IResourcePlanningClient resourcePlanning = (IResourcePlanningClient) this.teamRepository
.getClientLibrary(IResourcePlanningClient.class);
ResourcePlanningManager resourcePlanningManager = resourcePlanning
.getResourcePlanningManager();

IContributorInfo info = resourcePlanningManager.getContributorInfo(
this.user, true, monitor);
ItemCollection<IWorkResourceDetails> details = info
.getWorkDetails(this.user);
return details;
}





0 votes

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
× 12,031

Question asked: May 04 '17, 8:11 a.m.

Question was seen: 1,892 times

Last updated: May 11 '17, 4:18 a.m.

Confirmation Cancel Confirm