Question
Coforge
IN
Last activity: 23 May 2024 20:49 EDT
Best practices while configuring a Report Definition?
What are the best practices while configuring a report definition?
Accepted Solution
Updated: 23 May 2024 20:49 EDT
Eclatprime Digital Private Limited
IN
Below are the points to remember while configuring a Report Definition 1. Report definition, filter criteria that use function alias or ignore case matches will not use the database index even if it exists. 2. Use null if empty should be selected in filter criteria whenever possible 3. Always use columns in report definition filter criteria that are indexed. 4. Pega recommends having a maximum of 4 join conditions. 5. Applying sort or aggregate operations on more number of columns will results in poor performance.
Lantiqx Systems India Private Limited
IN
Hi @SivaramireddyT2951 please go through the below link for best practice for reports
Configuring rules to improve report performance | Pega Academy
Accepted Solution
Updated: 23 May 2024 20:49 EDT
Eclatprime Digital Private Limited
IN
Below are the points to remember while configuring a Report Definition 1. Report definition, filter criteria that use function alias or ignore case matches will not use the database index even if it exists. 2. Use null if empty should be selected in filter criteria whenever possible 3. Always use columns in report definition filter criteria that are indexed. 4. Pega recommends having a maximum of 4 join conditions. 5. Applying sort or aggregate operations on more number of columns will results in poor performance.