While at CA World 2015, I attended a demonstration of Jaspersoft and the person leading the demonstration was warning people from using Domains in Jaspersoft as it may create performance problems.
I have been looking for more information around this and have only found a few sparse comments here and there. Would anyone in the community have any real-world experience with using domains in Jaspersoft with CA PPM? If so, what have you found in regards to performance?
Below are some information
1. Any filters that are used in a report are applied in memory which causes performance issues
2. Jaspersoft do not support aggregations (Jaspersoft do not support aggregations in DOMEL, which is the domain language used in Studio reports for domain-based reports). DOMEL has limited functionality today.
3. Our recommendation is that customers write direct SQL Studio reports and not domain-based Studio reports.
Hope this helps
Once further question:
If I understand this correctly, we'll need direct database access to the custom database so we can write the queries. Correct?
With CA PPM, you can built reports on two database i.e PPM Schema & PPM_DWH and you will need read only access to the schema to write the reports.