In reports we found that a resource is missing in DWH_INV_SECURITY_V. They are able to see a certain project, when they log in, but when we query this view in Power BI/custom reports, it does not come up.
The view has other users' data and the Load Data Warehouse Access Rights has been run
Release : Any
Component : CA PPM DATA WAREHOUSE
Checking the rights we noticed no explicit Project View right granted to this user. User was a participant on the project and was able to see it as a participant.
This is by design, documented here:
https://knowledge.broadcom.com/external/article?articleId=197600
Project participants are able to see the project without Project View rights. But only Project View rights will be going in DWH_INV_INVESTMENT_V table.
Possible Workarounds:
Remove the user from the project participants
OR
Leave them in participants and not expect to have them in DWH
OR
Explicitly grant Instance Project View right and run Load Data Warehouse Access Rights job