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

[closed] Few project areas do not show in RRDI. The behavior is random

Hi,
We have configured RRDI with CCM.

There are more than 100 projects in CCM. But when I generate a report in RRDI, only few of them appears. And also, the behavior is random. Some day, some projects, other day, other projects appear.

If this will be the case, the reporting will be of no use because we need reports across many projects. So all required projects need to populate.
I have access to all the project areas. I am also added in JazzAdmin group.

RTC v5.0
Webpshere v8.5
Using LDAP
RRDI 5.0

0 votes


The question has been closed for the following reason: "We were unable to reproduce it anymore. Therefore closing this topic." by krzysztofkazmierczyk May 28 '15, 9:22 a.m.

Accepted answer

Permanent link
We were unable to reproduce it anymore. Therefore closing this topic.
Shuchita Tripathi selected this answer as the correct answer

0 votes


One other answer

Permanent link
Hi Shuchita,

Users see only the reports to which they have an access; not all reports from the server. It might be a case here.

But if you do not think that this is an issue, then please open a new PMR for the support to investigate it.

0 votes

Comments

Hi Chris,


Thank you for your reply.
I am the administrator of the server. When in query studio, I drag Project Name from ODS -> Request Area -> Request, i get only few projects (randomly). I have access to all the project areas in RTC.
Are you talking about any other access?

Hi Shuchita,
You should rather try ODS -> Project Area -> Name. What do you see now?

Hi Chris,

Now I see 72 project areas (earlier it was around 25).
However, in my environment, I have 120 project areas.
I want all project areas.

Hi Shichita,
1. But do you see now always exactl 72 PAs? Or behavior is rather random?
2. Do you see all PAs now from ODS -> Request Area -> Request?
3. Do you see any pattern which PAs are not visible (e.g. Archived ones only, or created long time ago)?

Just a note -- it doesn't matter if you are administrator of the server.  You still won't get visibility to the project areas unless your ID is listed as a member of the project. 

Hi Shichita,
When a project area gets modified in the data warehouse, a database trigger will clear the read-access list for that project area. Later, during the ETL, the read access list will be rebuilt. So the time between the trigger and and the completion of the read access list being rebuilt, you will notice the behavior you are seeing. I would recommend running the ETLs only during off hours. Another solution, is to disable read-access control in RRDI by deploying the proper flavor of the Data Model.

Hi,


The behavior is random. There is one important project in our environment which was appearing initially, but now it doesn't. I am a member of that project with admin rights.

showing 5 of 7 show 2 more comments
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
× 403

Question asked: May 11 '15, 4:16 a.m.

Question was seen: 3,632 times

Last updated: May 28 '15, 9:22 a.m.

Confirmation Cancel Confirm