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 |
If the Hi-rarchies are not defined in the universe level .Is it possible to do in the report level?
What is the difference between the public object&schema object?
What would you consider as your biggest achievement and why?
Explain about a task that really tested your analytical abilities?
What is the difference between the Webintelligence and desktopintelligence?
i want to hide a chart in reporting level? i want to hide a prompt in designer level?
can anybody tell me about issues faced while creating reports
1 Answers Accenture, Tech Mahindra,
What is broad cast agent?
WHAT KIND OF TOOL BO IS?
My data source is Excel sheet. How to write the SQL Statement for Excel file in data provider? Is is possible?
can i use stored procedure in webi?
What is the slice and dice?