User's project view rights are missing in DWH_INV_SECURITY_V

book

Article ID: 208899

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS STARTER PACK-CLARITY PPM

Issue/Introduction

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

Environment

Release : Any

Component : CA PPM DATA WAREHOUSE

Resolution

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