How to create bi publisher report using multiple PS queries in peoplesoft
Currently we are trying to achieve bi pivot table where data need to be fetched using multiple ps queries in excel.
Since the data is huge, xls can handle unto 65000 rows so we want to use multiple tabs in excel and try to create a pivot using them.
We can create a template with two/multiple tabs using different Queries, but when we create BIP report, We can use only one data source at a time and fetch data from single Query.
Can you advise if any alterative option can be used