How to address Oracle BIP report performance for Oracle finance dataset when data volume is growing
We have simple oracle account analysis report that pulls the data from from GL JE batches , GL JE headers and GL JE Lines. Our financial data is growing at unprecedented rate. During close we are observing report timeout issue, especially during close here. A period data now exceeds excel limit.
Here is the runtime comparison when same report is run for same parameter set during IST Hrs VS US hours during period close days.
| US Hours (Production) | Factor | |
|---|---|---|---|
| 234 sec | 14,006 sec |
|
| 27 min | 4 hrs 15 min |
|
This should be usually problem when companies data grow. I am checking here how this performance impact is getting address. Can Oracle Analytics Cloud a viable solution here.
Tagged:
0