Reports and Jobs - add custom report lookups database schema (Best Practices)

Products

• Clarity PPM On Premise

Issue/Introduction

We need to use Reports and Jobs to publish a custom Jaspersoft Studio report. Do we need to use the lookups created based on PPM_DWH schema or custom reporting schema, since the lookups created on Clarity schema would use live data?  Our reporting database schema would be refreshed once overnight.

Environment

Release : All Supported Clarity releases

Component : CA PPM JASPERSOFT

Resolution

At Broadcom Support, we recommend, when writing and publishing custom reports, to use best practices as follows:

Best practice: Always use the same schema for lookups and input controls.

For example, if your report is running against DWH, pick lookups and input controls that are running against DWH schema. If you don't, you may not get results for something that has not been loaded in DWH yet.

We suggest using the OOTB csk_rpt lookups, written against Data Warehouse schema

 Note: The same applies to Clarity schema, if the report query runs on Clarity, a Clarity lookup and input control should be used.