We are querying DWH_INV_SECURITY table for our reports and Power BI and noticed the information isn't updated. We have ran Load Data Warehouse Access Rights job already. What could be the problem here?
Release : 15.1+
Component : CA PPM DATA WAREHOUSE
You're actually looking in the old tables. Those are deprecated and as such may not work at all.
DW_INV_SECURITY table is deprecated, starting 15.1. Please see below:
From version 15.1:
You can refer the changes here https://techdocs.broadcom.com/us/en/ca-enterprise-software/business-management/clarity-project-and-portfolio-management-ppm-on-premise/15-1/reference/oracle-and-ms-sql-database-schema-changes.html
DWH_INV_SECURITY and DWH_RES_SECURITY are now views
NEW VIEWS PROVIDED FOR USE:
SUGGESTIONS FOR REPORTS
--------------------------------------------------------------------------
This is the documentation for 15.1 so since then the updates may no longer work at all. They were only kept so existing reports won't break until the customers switch to the new views.
Please stop using DWH_INV_SECURITY and DWH_RES_SECURITY ASAP and start using the views
We suggest you update all the reports using those views to have the correct updated data.