Cannot set Attribute to be included in DWH (if Object is unchecked)
search cancel

Cannot set Attribute to be included in DWH (if Object is unchecked)

book

Article ID: 98065

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

  1. Trying to configure an attribute to be included in the Data Warehouse in Studio:
    • Object: <object_name> | Attribute: <attribute_name>Object Attribute
  2. The Include in the Data Warehouse is greyed out, hence,unable to reconfigure the option.

Environment

Release: All Supported Releases
Component: Clarity PPM Data Warehouse

Cause

  • You are on the sub object for the attribute instead of the master object.

    • For instance, you are on the project object trying to include the attribute in the data warehouse, but the attribute was actually created on the investment object.

Resolution

  1. For your attribute, check the Database Table column.  It will show which object the attribute was created on.  if it shows INV_INVESTMENTS that means it is on the investment object.
    • Note: Not all attributes will have a database table name.
  2. Go to the Master Object properties page and Include in Data Warehouse there

Additional Information