Performance tuning in universe

How to create reports in universe easily?

Showing Answers 1 - 6 of 6 Answers


  • 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

  Was this answer useful?  Yes


  • 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.

  Was this answer useful?  Yes


  • 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!

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions