Clarity PPM - Access Rights information for Custom Investment Types not being loaded into DWH
Article ID: 192237
Clarity PPM On PremiseClarity PPM SaaS
Steps To Reproduce: 1. Create a Custom Investment Type object (Administration -> Objects -> New -> Object Extension = Investment Extension) 2. Navigate to the Modern UX and create a few instances of the object created in Step 1 3. Navigate to Administration -> Resources -> <Search for the account being used>. Provide Global Rights to it over the newly created object 4. Run Load Data Warehouse full load job. Wait till its completion. 5. Run the following query on the PPM Schema. Notice that the ID of the object defined in step 1 is listed: SELECT DISTINCT global_right FROM dwh_sec_global_right_v; 6. Run the following query on the DWH Schema. Notice that the ID of the object defined in step 1 is NOT listed: SELECT DISTINCT global_right FROM dwh_sec_global_right;
Expected Result: Custom Investment Types are listed in Step 6 Actual Result: Custom Investment Types are not listed in Step 6
The steps here miss running the "Load Data Warehouse Access Rights" job. This job is responsible for porting access rights from PPM schema to DWH schema.