Is it possible to include the column prnotedate in the table DWH_TME_ENTRY_NOTE?

Products

• Clarity PPM SaaS

Issue/Introduction

We want to know if it is possible to include prnotedate column in prnote table in the Data Warehouse

 

We need this information for our custom report in Power BI, the data is being captured through the oData and we do not visualize the field in question in the table "DWH_TME_ENTRY_NOTE".

Environment

Release : 15.9.1

Component : CA PPM SAAS DATA WAREHOUSE

Resolution

prnotedate column in prnote table was not available in Data Warehouse prior to version 15.9.3. Starting from 15.9.3 onwards prnotedate is in the Data Warehouse.