How to add Last Updated By and Last Updated Date fields to Data Warehouse and Jaspersoft Domains

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Is there a way to have Last Updated By and Last Updated Date available to be included in the DWH for Advanced Reporting when creating ad-hoc views and reports?

Environment

All releases with Data Warehouse

Resolution

Adding Last Updated By field:
1. Connect to PPM - Administration - Object
2. Open the Object needed - go to Attributes
3. Click on New to create a new attribute
4. Select Calculated as Data Type, and Result Data Type = String - click Save
5. Select Build a Calculated Attribute
6. Use function Concat, attribute name = Last Updated by
7. Click on Generate
8. Ensure the expression is valid, hit Save and Return.
9. Enable the new attribute for Data Warehouse
10. Run Load Data Warehouse job until completion

 

Adding Last Updated Date field:

1. Connect to PPM - Administration - Object
2. Open the Object needed - go to Attributes
3. Click on New to create a new attribute
4. Select Calculated as Data Type, and Result Data Type = Date - click Save
5. Select Build a Calculated Attribute
6. Use function DateAdd, Set Argument 1 name = Attribute Name - Last Updated Date
7. Set Argument 2 to Constant - Second (ensure the case matches)
8. Set Argument 3 to Constant - 0
9. Click on Generate
10. Ensure the expression is valid, hit Save and Return.
11. Enable the new attribute for Data Warehouse
12. Run Load Data Warehouse job until completion

 

You should then be able to find the new field in the Domains and use it in reports.

  

(Please note the screenshot examples were made with Benefit Detail object but any other object can be used with this solution). 

 

Data fields display in Domains and can be selected for Ad Hoc View:

     

Additional Information

The tip was first posted here, so you may see the full details and join the user discussion below:  

https://community.broadcom.com/communities/community-home/digestviewer/viewthread?MID=750312#bm9461b6ca-63d1-40f6-9808-10a9f9cf85c2

If there are attributes that you feel should be added to Data Warehouse for selection(by design), please join the Product Management Office Hours and bring up your idea for voting.