How to get Parent Task Name into Data Warehouse
search cancel

How to get Parent Task Name into Data Warehouse

book

Article ID: 388271

calendar_today

Updated On:

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)