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

external user data for RRDI reporting

Hi,

I was wondering, beside the FULL NAME, USERID and EMAIL, are there any other attributes for RTC user which are being retrieved from external registry, for example Microsoft AD, and stored in DW?
In DW database, I found out RIODS.RESOURCE table which has some fields indicating City and Organization.
My question is:
From where  these  fields in this table are being filled?
Because, we build some report and we would like to have an organization or department name for that user where he belongs to.
If these data are empty all time, I could use it for stuff like this.

Thanks, and regards,
Milan

0 votes


Accepted answer

Permanent link
the DW database is a common data warehouse, not only for RTC, but tools cross software development lifecycle.
RIODS.RESOURCE could store data from various sources, eg. RTC is one via RRDI, Microsoft Project is another one could provide more resource management capability via Rational Insight(a product based on RRDI has more customization capability).
So Yes, users from RTC will not use columns like City and Organization, you may use fill them from your own data.
Milan Krivic selected this answer as the correct answer

1 vote

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
× 12,019
× 7,494
× 403

Question asked: Jan 22 '13, 4:52 a.m.

Question was seen: 4,388 times

Last updated: Jan 22 '13, 9:22 p.m.

Confirmation Cancel Confirm