Performance issue webi report-BOXI3.1

[Former Member]

Hi,

We have a requirement for a report where we will give user a set of objects (26 u2013 31) to do analysis using interactive viewing feature. Here we are facing severe performance issues and memory issues as the data that we are calling is huge( around 6 million records). At the report level we will be summarizing the data.

No of rows in the report is depending on the no of objects.

Mode of view : Interactive view.

Note:

1. Objects which are using in conditional level those have indexes.

2. No of report level variable are two.

3. Version of Business objects: BOXI3.1

4. OS: Sun Solaris

Please let me know if there are any means by which the memory requirements for the report can be minimized/ performance of the report can be improved.

Thanks,

Subash

[Former Member]

Subash,

At the report level we will be summarizing the data ... any means by which the memory requirements for the report can be minimized/ performance of the report can be improved

Is there any way that you can summarize this on the database side versus the report level? The database should be sized with memory and disk space properly to handle these types of summarizations versus expecting the application to perform it.

Thanks,

John