Can we have Baseline Revision/historical info in DWH?

Products

• Clarity PPM On Premise

Issue/Introduction

Can Baseline Revision/historical information be included in the Clarity PPM Data Warehouse (DWH)?

Environment

Component: ODDWH

Resolution

Unfortunately, you cannot add Baseline revision/historical information into the DWH. Only current baseline data is available. See Article ID: 113480 for baseline information available in the DWH. 

Baseline is one of the objects that cannot be used in DWH without the implementation of a custom domain. Unfortunately, creating custom domains are outside of the scope of support but if assistance is needed in setting this up, we recommend checking out the documentation available at Advanced Reporting with Jaspersoft initiating a CA Services engagement to get this created for you. Below are some steps to assist around this functionality as well: 

To be able to bring historical baseline data which is currently not available in data warehouse: 1. Create a custom master object which you should be able to include in the DWH and then downstream to Odata. That custom object will contain the data you need to report on. 2. Create a process (workflow) in Clarity PPM which will utilize GEL script to copy the data from baseline stock tables to custom object created above. Your developer will need to make sure they code the gel in the sense that it takes care of the historical data, in other words when update versus insert into the custom object table.