brahmareddy

• Sep 3rd, 2015

 

There are different performance tuning stages in SAP business objects, we can use derived tables, short cut joins which can use in universe level and also predefined filters which help us to improve performance. While in report level I will use report filters, prompts to remove unnecessary data so that the performance increase

bala

• Jan 29th, 2016

 

In Universe,

1. We have array fetch size option in relation connection. In that we will mention the max. no. of row to be hit and extract form the data base for each time.

2. Reduce derived tables, because it doesn't have data. It is a virtual table, every time it hits the database and extract the objects so performance low with derived tables.

3. Using filters, LOVs,with aggregate tables, aggregate_aware function, the performance of the report increase in Webi report level

1. With complex formulas the performance decrease, try to split complex formulas.

2. Applying filters, input controls report performance increases.

3. With detailed level of data the performance of the report decrease.

Asish

• Nov 1st, 2017

 

Make sure proper schema design with dimension, measure, detail, proper join, mapping of of all parameter at Report level, We need to tune DB query for calculating all measure, dimension at report or Universe Report Tuning level!