Use XML Files in BI Publisher with PeopleSoft Batch Reporting
- PeopleTools Tech Tips
- Randy Groncki 2022-10-26
Walkthrough Documentation: https://peopletoolstechtips.com/use-xml-files-in-bi-publisher-with-peoplesoft-batch-reporting/
YouTube demo: https://youtu.be/jzwzykHWpK8
Running a BI Publisher report in batch doesn’t mean it has to use PSQuery as a data source. As per MOS (Doc ID 962712.1), an XML File is the most efficient way to feed the report data.
Just because most delivered BI Publisher reports in PeopleSoft use PSQuery as a data source doesn’t mean that is the best choice or the method you must choose. A PSQuery data source is inefficient, slower, and opens the possibility of someone breaking the report by modifying the public PSQuery.
This file contains all the objects referenced in the video and document.
Walk Through PDF PeopleTools Project This contains all the components, pages, BI Pub report definitions, records and PeopleCode used in the demonstration. The target database must be minimal 8.58 PeopleTools