search cancel

Expose underlying tables via ODATA used in view ODATA dwh_inv_security_v, dwh_res_security_v

book

Article ID: 200254

calendar_today

Updated On:

Products

Clarity PPM SaaS

Issue/Introduction

DESCRIPTION FOR RELEASE NOTES:

SUMMARY: Expose underlying tables via ODATA used in view ODATA dwh_inv_security_v, dwh_res_security_v

STEPS TO REPRODUCE: 

1. Prerequisite to reproduce the problem is to have medium size dataset with around 8+ million record in view dwh_inv_security_v, dwh_res_security_v 
2. Login to a system and navigate to Administration --> General Settings --> Data warehouse ODATA SERVICE
3. Use the DATA WAREHOUSE ODATA V4 ENDPOINT URL and connect via Postman 
4. Perform a GET Call https://cppmbixxx.ondemand.ca.com/api/odata4/cppmxxxxtDataSourceV4/DWH_INV_SECURITY_V

Expected Results: The API get call dwh_inv_security_v should be able to fetch records but it times out after 15 minutes 

Actual Results: The API get call dwh_inv_security_v takes too long in PostgresSQL

 

Cause

This is a defect DE57824 and fix is to expose the tables mentioned in the resolution section

Environment

Release : 15.8.1

Component : CA PPM SAAS DATA WAREHOUSE

Resolution

The below tables are exposed as part of ODATA API from 15.8.1 patch 2 

 

dwh_sec_user
dwh_sec_user_group
dwh_sec_group_hier
dwh_sec_group
dwh_sec_assign_perm
dwh_cfg_object_type
dwh_sec_perm_element
dwh_sec_global_right
dwh_sec_assign_right
dwh_sec_right
dwh_sec_unit_by_mode
dwh_inv_obs_mapping