How can I enable data chunking for high volume extracts?

Run the following payroll extracts for larger data sets using the XML Data Chunking feature of BI Publisher.

• Payroll Activity Report for the Latest Process

• Statutory Deduction Register for the Latest Process

• Payroll Register for the Latest Process

Note: You can split large volumes of report output into manageable chunks of XML files, to facilitate parallel processing and later be merged into a single report. The XML data chunking capability in BI Publisher reduces the time and memory used for processing large data. You can't use this functionality for PDF and text output of the report.

Do the following to enable XML chunking:

1. Use a process configuration group to enable BI Publisher to do the chunking of the high volume XML extract output.

2. Create a Payroll Process Configuration Group, set the Parameter to Y, and use this process configuration group to run the report.

Note: Although the output for each chunk is merged into a single Excel workbook, the output for each chunk will be in a separate worksheet in that workbook. Although the XML size at which BI Publisher performance begins to improve significantly by this feature can vary between customers due to extraneous factors beyond the control of the report. It's recommended to turn this feature on for report XML sizes greater than 1 GB.