You are querying the DWH_INV_SECURITY table for your reports and Power BI and noticed the information isn't updated. You ran the Load Data Warehouse (DWH) Access Rights job already.
You are looking in the old tables. Those are deprecated and as such may not work at all.
Release : 15.1+
Component : CLARITY DATA WAREHOUSE
DW_INV_SECURITY table is deprecated, starting in 15.1. See below:
DWH_INV_SECURITY and DWH_RES_SECURITY tables were removed. Refer to the changes here: Oracle and MS SQL Database Schema Changes. DWH_INV_SECURITY and DWH_RES_SECURITY are now views. These views exist so customer reports, etc won’t break. Don’t use these for new development!
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 you switch to the new views.
Stop using DWH_INV_SECURITY and DWH_RES_SECURITY ASAP and start using the views below:
We suggest you update all the reports using those views to have the correct updated data.
See also: Load DWH job frequently reported issues