Queries are performing poorly when using the view dwh_res_security_v & dwh_inv_security_v 
search cancel

Queries are performing poorly when using the view dwh_res_security_v & dwh_inv_security_v 

book

Article ID: 232752

calendar_today

Updated On:

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