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.
Release : All Supported Clarity releases
Component : CA PPM JASPERSOFT
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.