It's all about the answers!

Ask a question

missing current users team allocation % from APT_SNAPSHOT


Dave Decker (331516) | asked Jan 12 '11, 5:23 p.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...

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

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

3 answers



permanent link
Dave Decker (331516) | answered Jan 13 '11, 10:04 a.m.
Additional information:
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

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

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

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

permanent link
Christoph Schabert (112) | answered Jul 26 '12, 10:19 a.m.
+1   I'm searching too

permanent link
Dave Decker (331516) | answered Jul 26 '12, 10:29 a.m.
Data shows up but only after manually adjusting user assignment in RTC...

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.