Reporting Capacity in Pega Marketing
As part of a Pega Marketing campaign run, I am trying to extend the OOTB reporting capability with a couple of new reports to aid marketing simulations. The problem I am having is the amount of data being retrieved (upto 100k rows) and rendered on the screen (the reports have a number of aggregates). At these volumes, the report brings down the JVM (it does recover) after running out of memory (4GB heap). So my questions:
- What is the maximum number of rows that a report can handle with a heap size of 4GB?
- How can a trigger the direct export of the report to excel (real time, not scheduled) without running the report itself?
- Would the amount of data that just an export could handle be greater than running the report?