How can we improve performance?
Answers were Sorted based on User's Feedback
Answer / tilak
1)usinf aggregated tables
2)using shortcut joins
3)removing unwanted classes and objects
4)removing unwanted joins
5)lov should be based on smaller look up tables
| Is This Answer Correct ? | 5 Yes | 2 No |
What is the differrence between prompt & @prompt? What is the differrence between Xcelsius & Web-I Report?
Is import wizard, report conversion tool, report comparison tool, security viewer ---- where all r migrating tools. whether all the tools available in BOXIR2? ..
What is #DATASYNC error how to remove it?
what is maximum scope of analysis --> can we define more than 3 levels?
how to restrict null values in webi report?
WHAT ARE THE INDEXES THAT SUPPORT DATA WAREHOUSING ? Thanks In advance Prakash
bo 6.5 is a 3 tier architecture. Tell me the names of the tiers?
What is self join
what is performance tunning in BO in report level& designer level?
How to create Index to the table in the universe designer and how it improves the Query performence
. User wants to modify a report and wants to add additional data. How will you approach.
while developing a report in BO i had created prompts at query level? When an end user runs the report he has to see the details of the report with out entering the prompt values? How can we do this in BO?