DWH_CFG_AUDIT for tables RPT_INV_HIERARCHY, RPT_CALENDAR, RPT_RES_SKILLS_INDEX

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

When we run Load Data Warehouse, it also updates the tables:

rpt_calendar, rpt_inv_hierarchy and rpt_res_skills_index

But the tables is not updated in DWH_CFG_AUDIT. We want the update to be added to DWH_CFG_AUDIT for us to monitor.

 

 

Environment

Release : 15.8.1

Component : CA PPM DATA WAREHOUSE

Cause

We run Update Reports table as part of Load Data Warehouse job. It is run on the Clarity schema so this is the reason it's not included in the DWH updated tables in DWH_CFG_AUDIT.

Resolution

We created a new feature to track delivering the ability to include rpt_calendar, rpt_inv_hierarchy and rpt_res_skills_index in DWH_CFG_AUDIT enabling customers to monitor that information.

This is now in Product Management's backlog. If you need any information on this in further, please join the Product Management Office hours.