BusinessObjects Board

improve the report performance

building semantic layer
#1

hi folks

can briefly explain about report performance?

  1. how did u improve the report performance
  2. if the report is not refreshing properly or showing some errors, how can we clarify on those bugs
  3. if query level means what we have to play on sql part?
  4. while running the report it will take lot of times, in this case what to do ?

thnaks in advance
velu

velmani (BOB member since 2008-06-05)

#2

Hi …

  1. how did u improve the report performance

  2. if the report is not refreshing properly or showing some errors, how can we clarify on those bugs

  3. if query level means what we have to play on sql part?

  4. while running the report it will take lot of times, in this case what to do ?

  5. It depends upon the DB you use and the number of values in your table ,there are few optimization that could be done but that too concerns with the specific report you deal with.
    2.That depends on the scenario and the error prompted
    3 & 4 … It too couldnt be anything generic… for 4. Execute the query you generate in some SQL assistance to see the duration taken, also check the total number of rows to be fetched. If it is of high number then the report runs longer or it may be the order of tables in “From” clause.

Goutham (BOB member since 2008-08-20)

#3

See this FAQ entry: Why is my report so slow?

Andreas :de: (BOB member since 2002-06-20)