It's all about the answers!

Ask a question

RTCLive APT_SNAPSHOT CONTRIB_ASSIGN not ret. all rows


Dave Decker (331516) | asked Jan 14 '11, 10:39 a.m.
We're using Report Studio in Rational Insight to report on RTC users team allocation percentages; We've exposed RTC CONTRIBUTOR_ASSIGNMENT table through APT_SNAPSHOT, but current users team assignments percentages don't show up in snapshot unless they're updated MANUALLY, PER USER in the RTC Admin USER UI and saved...

issue arises when running an IBM Rational Insight Report developed via

IBM Cognos 8 BI Report Studio version 8.4.1

RTC Environment:
Jazz Foundation - Jazz Team Server 1.0.0.2 iFix 4 I20100903-0816
Rational Team Concert 2.0.0.2 iFix 4 I20100903-0816

Is there a way to get this to populate correctly without manually updating each RTC users team allocation percent and saving?
thanks
dave d

RTC
RTCLive
APT_SNAPSHOT:
Table Logical Name: CONTRIBUTOR_ASSIGNMENT
Table Database Name: CONTRIBUTOR_ASSIGNMENT
FACT_ID
TIME_ID
PROJECT_AREA_ID
TEAM_AREA_ID
DEV_LINE_ID
CONTRIBUTOR_ID
ASSIGNMENT

One answer



permanent link
Rafik Jaouani (5.0k16) | answered Jan 20 '11, 11:17 a.m.
JAZZ DEVELOPER
In RTC 3.0, we dropped the CONTRIBUTOR_ASSIGNMENT table for the reasons you outlined. None of our reports used the table.

Your answer


Register or 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.