BIP Report Out of Memory (Can LIMIT display, without affecting Export?)

drudd

So I have a large BIP report. I do display paramters, row counts and time all at the top of the report.

I want the user to be able to see the report before they export it so they can understand what's on the report and have a sample of information that will be exported.

I was wondering if there's a way to display the first 1,000 rows or 10 pages or something like that in an HTML format so when they open the report they can see this information. However, I want the export to extract all the data based on the parameters used. While 100,000 isn't hard for CSV/Excel when I display the full report I get an out of memory error and it crashes the browser window.

Kevin M-Oracle

Best practices: Large reports should be scheduled not viewed.

There is no preview, but you could try a parameter that reduces the output size such as number of invoices.

They could review a subset of data, then schedule the full dataset.

Rgds,

Kevin

drudd

Thanks for the response. I did enable pagination and that allowed it to load better.

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/comment/66393#Comment_66393

Hi ,

Thanks for sharing the update. Are you able to share the exact steps with community for future references?

Thanks.

drudd

https://community.oracle.com/products/oracleanalytics/discussion/comment/66479#Comment_66479

Sure so you will go to you report:

1. Click Edit Report
2. Click Properties
3. Click the Formatting tab
4. Scroll to the HTML Output section
5. The option "View Paginated" set to True

When I load the report this way it seem to display the first page much quickly than without pagination. It does still take a while to load, but I'm guessing as soon as the query is complete and it's rendered the first hand full of pages it will display. I've noted if I skip to last page right away it will cause an error, but if I way a bit it will work just fine. The first page is normally where I put most of the important information Parameters, Time Run, Row Count. So that's the main thing I care about right away. I also will see the first dozen rows. From that first page I can tell if I ran something wrong or not. I'll also take a screen print of this for audit purposes.

I will export to csv which works best for large datasets.

I hope that helps

My parameters, time, but not row count display in the csv results. I wish I knew how to avoid that in the csv export, but include it in the HTML display and all other exports (PDF, Excel, HTML). I also wish I knew how to get my row count to display in the csv (in case I wanted that in the future).