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
|
Accepted answer
Benjamin Silverman (4.1k●6●10)
| answered Jul 02 '14, 1:41 p.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
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
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.
Benjamin Silverman
commented Jul 02 '14, 2:00 p.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
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,
|
