Not able to run Transaction register for the duation of one month

Summary: We have 300K transactions per month and OTBI transaction register is not able to pull the data when we execute the report for one month. We are able to get the data, if we run for 10 days, but running the report for 30 days is not working and showing not enough memory.

Content (required):

Normally, we cannot export the data, if more than 75K records using OTBI , but at least we should be able to see the transactions in the screen.

We went live recently and users really need to be able to run reports at least by month. We cannot ask users to run report for each 10 days and do the consolidation, specially during month end reconciliation.