This content has been marked as final. Show 3 replies
It is taking about the memory limit for IR job service which is 1536.That is the memory limit it can handle.if anything goes beyond ,the query will fail.
a couiple of issues/questions here.
Do you really have a report that shows 3.5 million rows of data on it? That is a bit extreme for an Analysis/Report
how many columns wide is the data? how big is the file on the desktop uncompressed with all the data? are you doing sorts or computed columns in the BQY on the data? How many Chart, Pivot, Report sections
What is your EPM install 32bit or 64 bit?
You might want to look at:
- Aggregating data in Query or Database.
- Using a different Tool. (Production Reporting (SQR)
- if using 64bit increase the JVM settings (min/max) for BI service.
The real issue seems to be when we carry over the data from the results to bqy table sections. We have since split up the query with various limits, and are writing to Oracle tables instead, and then pulling it from Oracle into the bqy for our analysis. We had already played with the JVM settings in our 64-bit system.
We will be moving towards OBIEE pretty soon here.Just wondering if it is any different from IR in handling huge volumes of data.
Thanks for your insight.
Edited by: 937685 on Jun 7, 2012 8:54 AM