It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×5,996
×1,235

question asked: Apr 05 '17, 4:05 p.m.
question was seen: 1,343 times
last updated: Apr 06 '17, 1:04 p.m.

Related questions

FAQ - How this Forum works

Report Builder Project prompt is not populated correctly

1
Steve Mulligan (176●13●21) | asked Apr 05 '17, 4:05 p.m.

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.

I looked at the raw data from the Data Manager JFS_ReadAccess Fact Build and it is not getting all the data from the CCM source.  I run the DataSource query with the CCM ResourceGroup and a Modified Since value of '1899-12-31 00:00:00' to get all data.  It returns 6389 rows, but there should be more than that.  The userid I am using for the XML configuration has Administrator access to the CLM server, so can see all the data.  Some projects have all the required users in the ROJECT_RESOURCE_LOOKUP table, but most have just a partial list.

The JFS_ProjectArea Fact Build get all 107 CCM projects successfully from the CCM server.  Why is the JFS_ReadAccess Fact Build not getting all of the source data from the CCM server?

One answer

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Francesco Chiossi (5.7k●1●11●19) | answered Apr 06 '17, 4:05 a.m.

Hello Steve,

is your user a member of the missing projects or can he just see them in CLM because it's JazzAdmin?
In the second case that's probably not enough. unless the project is visible to everyone.

Best Regards
Francesco Chiossi

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,

I meant the user running the report, not the one configured to run the ETL.

Best Regards
Francesco Chiossi

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

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.