How to get Parent Task Name into Data Warehouse

Products

• Clarity PPM SaaS

Issue/Introduction

The task attributes:  Parent Task Name and Parent Task ID are not available in the data warehouse.  There is a task hierarchy table available but it is not used to show the parent task information.

 

Environment

Clarity 16.2*, 16.3. 16.3.1

Resolution

In order to make these fields available in the Data Warehouse you can create calculated attributes and include those in the data warehouse.

An example is:

• On Task Object / Attributes
• Create a new attribute
• Data Type: Calculated
• Result Data Type:  String
• Expression: Concat(parent_task_name)
• Assign an API attribute
• Include in Data Warehouse

You can do the same for the parent_task_id

The fields then show in the DWH_INV_TASK table (DWH schema)