[closed] Few project areas do not show in RRDI. The behavior is random
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
One other answer
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.
Comments
Hi Chris,
Hi Shuchita,
You should rather try ODS -> Project Area -> Name. What do you see now?
Hi Chris,
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,