Performance tuning

[Former Member]

My Report is Taking to much time for Opening.

How can we do the Performance tuning at Report Level and Universe Level.

[Former Member · Accepted solution]

Hi,

Here are the few points for Performance tuning at Universe level in BO:

<< Universe Level >>

• Modifying the Array Fetch parameter (advanced parameters window of connection. Just edit connection in Universe and click twice Next. or we can control this parameter in CS.CFG file. Bigger number = faster query but it should be set up according to capacity of memory)
• Allocating table weights
• Using shortcut joins
• Using aggregate functions
• Creating and using aggregate tables
• Minimizing usage of derived tables

Here are the few points for Performance tuning at report level in BO:

• If you insert the Page Number/TotalNumberOfPages cell or the TotalNumberOfPages cell into a large report with many pages, Web Intelligence takes longer to return the data to the report.
• Opting for Refresh At-Will over Refresh-On-Open
• Not associating the List of Values (LOV) Objects which you don't want to use as a prompt
• Using universe Condition Objects, try to restrict/filter the data at universe end rather than at the report end.
• Keeping Complex Calculations at universe side.
• Minimizing usage of Report variables/formulas
• Auto height and auto width on report cells sucks in resources. setting cell sizes to fixed increases performance.

[Former Member]

Hi,

If you have covered up points suggested by Ravi and still have the same issue then you should also consider server side tunning process. The following links may be very helpfull in this regard.

http://dhigtana.wordpress.com/2011/07/14/performance-tuning-web-intelligence-processing-servers/

http://www.dallasmarks.org/blog/2011/11/sizing-the-adaptive-processing-server-in-bi-4-0/

Regards,

Shakeel