Report Builder Project prompt is not populated correctly
The Report Builder Project prompt is not populated correctly. It does not show the Projects a user has access to. I believe Report Builder gets this information from the PROJECT_RESOURCE_LOOKUP table in the data warehouse. I am using CLM and Rational Insight 6.0.3 and using the RI ETL to populate the data warehouse. I can manually add user and project combinations into the PROJECT_RESOURCE_LOOKUP table and it will be reflected in the Report Builder project prompt, but it is not possible to manually keep that table up to date with CLM.
|
One answer
Hello Steve,
Comments
Steve Mulligan
commented Apr 06 '17, 7:06 a.m.
The userid for the ETL is not a member of all the projects. However, even the projects it is a member of do not return all the users for the project. The userid for the RI ETL is supposed to just have Jazz Admin access rights. It works fine for all other RI ETL jobs, and I shouldn't have to add the ETL userid to each project as it is created.
Francesco Chiossi
commented Apr 06 '17, 7:22 a.m.
Hello Steve,
Steve Mulligan
commented Apr 06 '17, 1:04 p.m.
Yes, the user running the report is a member of the project. None of the users have Jazz Admin access rights. For example, I have one project with 250 members, but only 6 are in the PROJECT_RESOURCE_LOOKUP table. |
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.