Unable to add attribute in DWH if associated to a master object

Products

• Clarity PPM On Premise

Issue/Introduction

Unable to add the attribute in Data Warehouse (DWH), when we create a new attribute with same values, we are able to add in DWH.

Cause

• The Attribute belongs to an object of type “Subobject” and the attribute is “inherited” from the Master. The Attribute needs to be configured on at the Master object level.

• Example: The Attribute belongs to an out of the box object, like the Project object, but it is inherited from the Investment object.
  You can identify those attributes that fall under this scenario if they appear under a different Database Table IE INV_INVESTMENTS, instead of odf_ca_project.

Environment

Release: All Supported Release
Component: PPMDWH

Resolution

Verify if it should be associated / included via a different object: 

• • Check the database table name and the database table column name for each of the attributes and check the schema for those attributes. 
  • If they belong to another table and a different object, check if it can be included in the data warehouse on the other object.

Example: If the attribute was created on the Investment attribute, that is where you would include it in the DWH

Additional Information

KB: 124679 - How come I am not able to include some attributes or fields in the Clarity PPM Data Warehouse?
KB: 98065 - Unable to configure an Attribute to be included in the Data Warehouse (DWH)