@Syamantak Saha that could be the problem as the nature of the analysis requires substantial AP invoice line data. I'm not sure how to check the resources being allocated for the queries. I am system admin but it's not something our implementer covered. Can you assist with where I can find the information in the console?

Thanks for replying @Syamantak Saha , I'm one of our Fusion and FDI admins with full access therefore don't think this could be the issue?

We are just over a month away from our implementation date and I have just come across this limitation. We expected to be able to extract large volumes of data via OTBI analysis e.g. all general ledger transactions for the period but the 25000 limit appears to make that all but impossible. Very concerning.