It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×42,787
×11,924
×1,235

question asked: Sep 04 '13, 5:20 p.m.
question was seen: 4,482 times
last updated: Sep 05 '13, 9:54 a.m.

Related questions

FAQ - How this Forum works

No relationship between resource and team or project

0
John Stonehocker (11●7●6) | asked Sep 04 '13, 5:20 p.m.
Using RRDI with RTC 4.0 and there is no relationship established between a resource and a project or between a resource and a team in the DW. Without this how does a customer get a list of users by project or users by team by project to support internal audits?

Accepted answer

0
permanent link
Francesco Chiossi (5.7k●1●11●19) | answered Sep 05 '13, 9:53 a.m.
edited Sep 05 '13, 9:54 a.m.
Hello John,

I think you can get the information on Project and Resources from the following sections of the data model:
  • Operational Data Store > Project Area > Project
  • Operational Data Store > Project Area > Project Related Resources

For an example you can try inserting in query studio the following fields:

  • Operational Data Store > Project Area > Project > Project ID
  • Operational Data Store > Project Area > Project > Name
  • Operational Data Store > Project Area > Project Related Resources > Resource ID
  • Operational Data Store > Project Area > Project Related Resources > Full Name

Best Regards

Francesco

John Stonehocker selected this answer as the correct answer

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.