search cancel

How to add resource team information in Investment Domain in Jaspersoft

book

Article ID: 215092

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

We need to add tables DWH_INV_TEAM_DEF and DWH_INV_TEAM_MEMBER tables to a copy of the Investment Management Domain. We need the resource team information to be able to query it.

Environment

Release : Any

Component : CA PPM JASPERSOFT

Resolution

  • Some of the information is already in DWH_RES_RESOURCE table, you can get the team_def_key there without having to add anything to the Investment Management domain.
  • If you still need the other information, you have to use a copy of the Investment domain, add the tables and join them using the team_def_key and then pull the columns you want to display.