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
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com
what is universe null
What are the steps to do to use alerts in bo?
how get the grand total in master-detail report?
i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?
what is document design in boxi,have u participate in that
Which versions are used in the bo dashboard work?
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...
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
How to generate the report from excel sheet?
explain in detail about type 3?
Explain when to use local filter and when to use global filter?
Explain what would you consider as your biggest achievement and why?
If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?
What would you consider as your biggest achievement and why?