Interested to Buy Any Domain ? << Click Here >> for more details...
how to improve the performance of the report
- 3 Answers
- 6723 Views
- I also Faced
- E-Mail Answers
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 |
what is local filter
How would you format some text using css to be verdana and bold?
Hi friends, How many types of dimentions are they ?What are they? Thanks in advance
how can u find the granularity in fact table
Which versions are used in the bo dashboard work?
How to fix the order of Prompts? How to assign the default value in prompt?
what will be the contents for a functional requirements specifications
What Is Snow Flake Schema?
what are the tables used in health care domain project and columns used in report?
What is the diff b/w BO webi reports, crystal reports and xcelsius ? Thanks...
I have 2 structures in universe,but i can't link the structures b'cos no related columns,so what i have 2 do to link dat and if don't link them can i get data of 2 structures in the report that i run?
how many micro cubes can a report can have
Teradata 
