how to improve the performance of the report
Answers were Sorted based on User's Feedback
Answer / vams_gk
to inprove the performence of the reports we have multiplw
ways in my view. for example
1)generate LOV for required objects
2)use aggregate tables in universe design
3)use pre defined conditions and formulas.
4)check context (if there resolve it)
5)check loops (if there resolve it through alias table)
if u did u all these at universe level,when u generate the
report at query panel level automatically performence will
increese
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / ratnakar neti
To improve the performance of Reports we have to check the
following .
1.check the number of subreports.If more number of
subreports are there it will kill the performance of the
report
2.check the loops. We have to reduce the no.of loops to
increase the performace of report
3.generate the Lov's
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / babu
Report performane will improve by the given following
things.
1. Should disable LOv's for unnessary measure objects.
2. Create conditions at Universe level and try to reduce
the variable's and bulit complex logic's in universe and
database level.
4. use query level filters.
| Is This Answer Correct ? | 0 Yes | 0 No |
Can more than 1 metric be applied on an analytic in business objects?
plz tell me about BOmain key in detail?
every reports have docid,when i export a report docid will change or not?
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
Can we edit BOMain.Key file to connect with other repository with same supervisor user name and password. But Database is different.
How to create an popup in the WEBI report if the report is showing partial result?
How to change font color of values in hyperlinked columns?
what is casual dimension?
how can we join two classes with full outer join.in join dialog box only one outer join check box is checked another on e gone .for this any property is there in universe designer?
how to sort on a particular object,that object is not picked up while creating the cross tab but we need to sort on the object that is not in the cross tab????
2 Answers Infosys, Keane India Ltd,
what is difference between Rich client web intelligence and Boxir2 web intelligence
it is possible to link two universes of separate functional domain ?