Unable to see records in DWH_INV_SECURITY and DWH_RES_SECURITY tables

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

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.

Cause

You are looking in the old tables. Those are deprecated and as such may not work at all. 

Environment

Release : 15.1+

Component : CLARITY DATA WAREHOUSE

Resolution

DW_INV_SECURITY table is deprecated, starting in 15.1. See below:  

From version 15.1:

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!

NEW VIEWS PROVIDED FOR USE:

• DWH_INV_SECURITY_V: Main investment DB view for security
• DWH_RES_SECURITY_V: Main resource DB view for security

SUGGESTIONS FOR REPORTS

• Do not use the following views to build new reports. The views were created to support the existing reports that were based on the deprecated tables. The existing reports will still work but you may experience slow performance:
  • DWH_INV_SECURITY
  • DWH_RES_SECURITY
• Use the following views to build new reports:
• • DWH_RES_SECURITY_V
  • DWH_INV_SECURITY_V

---

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:

• DWH_RES_SECURITY_V
• DWH_INV_SECURITY_V

We suggest you update all the reports using those views to have the correct updated data.

Additional Information

See also: Load DWH job frequently reported issues