Queries are performing poorly when using the view dwh_res_security_v & dwh_inv_security_v

Products

• Clarity PPM SaaS

Issue/Introduction

Performance Issue. Queries are performing poorly when using the view 'dwh_res_security_v' & 'dwh_inv_security_v'. 

Steps to Reproduce: 

1. Use ODATA and create a report using any third party tool like Tableau/power BI
2. Use the view dwh_res_security_v & dwh_inv_security_v  for managing the report security 

Expected Results: The reports using the view dwh_res_security_v & dwh_inv_security_v  should efficiently work. 

Actual Results: The reports using the view dwh_res_security_v & dwh_inv_security_v for large customer never finishes . 

Environment

Release : 16.0.0, 16.0.1, 16.0.2 

Component : CLARITY DATA WAREHOUSE

Cause

DE63862 

Workaround:

• Until the views 'dwh_res_security_v' & 'dwh_inv_security_v' are optimized, please use the table instead of the view 
• Reference this KB Article for more details 

Resolution

Targeted Fix in Release 16.0.3