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

Can I reuse the Project Management Metrics model and DW tables in Rational Insight?

 I need to expose project management metrics in Rational Insight around earned value: BCWS, BCWP, ACWP, BAC, EAC, etc.  All these things are already defined in the Reporting Data Model (DW) in Rational Insight.  However, the underlying tables in RIODS do not seem to be populated by any of the ETL jobs from RTC.

Is it ok for me to leverage the DW tables to populate my own metrics data, or does IBM have a design on these tables for some other purpose?  I cannot find any documentation on these tables.  This is just like finding a bunch of dead code in a program, but nobody seems to know why it is there or what to do about it.

Thanks,
Robert

0 votes


Accepted answer

Permanent link
Hi Robert,

To my knowledge, those metrics were never loaded by any of our out of the box ETL's, but were added to support custom ETL's for FocalPoint and MS Project.  Assuming you are not using those, feel free to use them.  However, it's worth noting we do have enhancements open for loading some of those same metrics with CLM data.  Hope it helps,
Robert Huet selected this answer as the correct answer

0 votes

Comments

Thanks, Ben, that was my suspicion, but it is good to get confirmation.  I will look for that enhancement request so that I can subscribe to it.  That would be a great enhancement for customers who are still using the traditional process in RTC.

Actually now that I look at the enhancement, I see that it's closed and this code was added to the Data Collection Component (DCC).  So if you are using DCC to load your DW, this data will be loaded.  See my screenshot attached. 




Hi Ben,

Is there more insight what data in Project Management Metrics tables is populated and what not?
For example, I noticed that in "Resource Utilization Metrics" table, "Total Actual" show values, but "Total Assigned", "Total Allocation", and "Total Availability" showing 0.
Thanks in advance!

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.

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
× 10,937

Question asked: Jul 02 '14, 12:07 p.m.

Question was seen: 3,946 times

Last updated: Feb 07 '17, 3:09 a.m.

Confirmation Cancel Confirm