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 |
normally we get many contexts when resolving loops or traps,how do u take them to reports.
6.what is conformed dimension? R u used?
What is meant by Adhoc reports?Can any body will explain with examples...Thanks in Advance .........prakash
HOW YOU WORKED WITH MULTIPLE DATA SOURCES?IF YES ?HOW DO YOU LINK THEM?
what is the core universe and what is the active universe?
Explain what sort of existing documents should business analysts refer to when starting on a new project?
How can I display the query execution time for a particular DP on Web-I report? Or is there any other way to know the 'exact query execution' time at BO end?
BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...
Any body help me...what are challenges did u face in Business object project?
. In production reports, some dimensions are missing. how do you load these dimensions in production
Where will you find the address of repository in Business Objects?
User name and password is saved by Business objects when we create repository. and this username and password is saved in Table obj_m_actor table in repository. The password in incrypted form. It is possible to Dycrypt That Password.