What are the best practices while configuring a report definition?
Hi @SivaramireddyT2951 please go through the below link for best practice for reports
Configuring rules to improve report performance | Pega Academy
You can go through this link.
Below are the points to remember while configuring a Report Definition
- Report definition, filter criteria that use function alias or ignore case matches will not use the database index even if it exists.
- Use null if empty should be selected in filter criteria whenever possible
- Always use columns in report definition filter criteria that are indexed.
- Pega recommends having a maximum of 4 join conditions.
- Applying sort or aggregate operations on more number of columns will results in poor performance.