Answer Posted / 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 |
Post New Answer View All Answers
What is a fantrap in business objects?
What is package in BO
How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)
What is the profile and package?
What sort of existing documents should business analysts refer to when starting on a new project?
Explain what is the difference between slice and dice and cross tab report?
What is the difference in creating filters in designer and business objects?
what is xcelsius architecture?
Explain about a time when you discovered a more efficient way to do a work task?
Explain the difference between union and group?
Can anybody tell me what are the tuning problems?
Explain how we drill up week to month?
can anybody tell me about complicated object you have created
Did you face any problems while creating reports? Name? Solutions?
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...